Date () issue..

[Petros]

Hi all,

i use this in the criteria for "due" date

<=Date()..but for some reason..it does not return correct values..alos future dates becomes displayed...

Why?

Thanks!

 

[boblarson]

Are you sure your date field is truly a date field and not text?

 

[the_net_2.0]

another thing to note here is that queries don't always return syntax errors when other data types are substituted for what are supposed to be real dates. It will run, but the engine will automatically substitute is "1/1/1900" in for the supposed "date" field if is, say, a number...or sometimes even for a text string.

 

[Petros]

Are you sure your date field is truly a date field and not text?

Its a date field..but i found out i need to format it... dd-ddd-mmm-yy..now it works..strange

Thanks!