RowFilter on Date field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Manoj Paramu Das - 20 Apr 2005 17:56 GMT

Hi,

I have loaded an xml file to a dataset and one of the fields being
"UserDate" and has date values like
<UserDate>2005-01-01T00:00:00.0000000-05:00</UserDate>
I am trying to apply a row filter to this field and it doesn't seem to work

dvCMonth.RowFilter = "Month(UserDate)=" & Now().Month

dvCMonth.RowFilter = "Month(UserDate)='4'"

no matter what I try, it doesn't work however, Any help would be appreciated
and thanks in advance.

Manoj Das

Reply to this Message

Dinesh Kumar Sharma - 20 May 2005 18:03 GMT

Is anyone free tonight...i need urgent help for something,if yes,pls reply
back at sunena_sharma@yahoo.com or sunena@starhub.net.sg

i hv one small requiremnt tht needs to be finished in next 6 hrs, anyone has
time for it.

> Hi,
>
[quoted text clipped - 11 lines]
>
> Manoj Das

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...