HighTechTalks DotNet Forums  

RowFilter on Date field

Dotnet Academic General Discussions microsoft.public.dotnet.academic


Discuss RowFilter on Date field in the Dotnet Academic General Discussions forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
Manoj Paramu Das
 
Posts: n/a

Default RowFilter on Date field - 04-20-2005 , 12:56 PM






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 With Quote
  #2  
Old   
Dinesh Kumar Sharma
 
Posts: n/a

Default Re: RowFilter on Date field - 05-20-2005 , 01:03 PM






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

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



"Manoj Paramu Das" <manojpdas (AT) msn (DOT) com> wrote

Quote:
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 With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.