Dynamic date in my query

  • Thread starter Thread starter Fred
  • Start date Start date
F

Fred

Hi, this is a part of my query :

WHERE (((TEMPS.DATE)>#03/1/2004#));

Now, I d like to put dynamically the current month in my query.. how to do
this ?
WHERE (((TEMPS.DATE)>#Month(Now())/1/2004#));
desoent wor kat all..
 
Fred

You didn't mention whether this was a query being built in design mode, or
via an SQL statement.

If your objective is to compare with the first of the current month, you
could use the DateSerial() function as a criterion. For example, your
criterion "cell" in the query designer could hold something like:
 
Back
Top