MSQuery date criteria using 'today's' date

[LinsayPatterson]

I've been following a previous (now closed) thread on this & see there was not a conclusive solution.

For returning the date using MSQuery:

>=GetDate()


For returning today minus 65 days use:

>=(GetDate())-65

 

[SkipVought]

Hi,

Welcome from Up Over (Texas) to Down Under! My mate is my wife and my knife is not so big.

Do you have a question?

Just an observation on returning today's date. It all depends on the database you are accessing. So if you have a question, please include the database you are tapping.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[LinsayPatterson]

On further inspection I found some issues with that previous code & found this one is much better:

>=current_date()-62