DateExpression

S

subbu

Hi,
I want to get the date range for the last 12 months
including the current month.
How to specify expression

regds
subbu
 
J

John Spencer (MVP)

BETWEEN DateSerial(Year(Date()),Month(Date())-12,1)
AND DateSerial(Year(Date()),Month(Date())+1,0)
 
S

subbu

Thanks for the function.where to specify the function and
how to pass the column name to evaluate

subbu
 
J

John Spencer (MVP)

You would put this as criteria in your query against the date field. In the
query grid that would look something like

Field: SomeDateField
Criteria: Between DateSerial(... AND DateSerial(...
 
Top