P
precious
I want to define a rowfilter like this:
dataview.rowfilter="WeekOfYear(datecolumn)=WeekOfYear(Now)"
Can anybody help me?
TIA
J Justin
N.B I tried like this... but didn't workout...! (The error was "expression
contains undefined function call DatePart()")
dataview.rowfilter= "CONVERT(DatePart(DateInterval.WeekOfYear,
Punch_Dt),'System.String')='" &
DatePart(DateInterval.WeekOfYear, sysToday) & "'"
dataview.rowfilter="WeekOfYear(datecolumn)=WeekOfYear(Now)"
Can anybody help me?
TIA
J Justin
N.B I tried like this... but didn't workout...! (The error was "expression
contains undefined function call DatePart()")
dataview.rowfilter= "CONVERT(DatePart(DateInterval.WeekOfYear,
Punch_Dt),'System.String')='" &
DatePart(DateInterval.WeekOfYear, sysToday) & "'"