DateExpression

[subbu]

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

regds
subbu

 

[John Spencer (MVP)]

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

 

[subbu]

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

subbu

 

[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(...