how to do trunc() in rowfilter ?

  • Thread starter Thread starter anand
  • Start date Start date
A

anand

hi,

what keyword should, to be assigned to the 'dataview.rowfilter'
property, to replecate the keywords like 'trunc' and to_date' of
any sql query ? i have a datetime column and i need to take only the
date portion for comparing to a user entered date.


anand
--
 
AFAIK,trunc() isn't supported but Like is .. WHere columnWithDate Like
'%DatePart%'
 
hi william,
AFAIK,trunc() isn't supported but Like is .. WHere columnWithDate Like
'%DatePart%'
Click to expand...

'like' with '%' didn't work :( i have tried many combinations of them:

"MOD_DATE like '#9/3/2004 %:%:% PM#'"
"MOD_DATE like '#9/3/2004%#'"
"MOD_DATE like '9/3/2004 %:%:% PM'"
"MOD_DATE like '9/3/2004%'"
and so on ...
but i get one or the other error during runtime. any other suggestion ?

anand
--
 
Back
Top