buty
asked on
Filter DateTime?
Hi every body ..
I have datawindow with column of type "datetime" ,if I made filter on this column there is error message said "Type of expression must match".
Any body tell me How I make filter on datetime column?
Regards
I have datawindow with column of type "datetime" ,if I made filter on this column there is error message said "Type of expression must match".
Any body tell me How I make filter on datetime column?
Regards
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Or
dw_1.SetFilter("datetime(d atefield)= datetime(' dd/mm/yy') ")
dw_1.SetFilter("datetime(d
Hi,
paste the filter condition u have given in the appln.
Regards,
Sandhiya
paste the filter condition u have given in the appln.
Regards,
Sandhiya
if ur applying a filter during design time then try the following,,,
UR filter criteria:
<columnname> = Date('12-12-2004') // or,
<columnname> = Date(arg_date) // where arg_date is ur argument...
assuming ur column name is <columnname>..
try passing ur argument as a date...
by using Date() ur type of expression must match error wont pop...
if this doesn't help paste ur code...let me check where u go wrong...
Cheers,
Rosh