DateExpression

  • Thread starter Thread starter subbu
  • Start date Start date
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
 
BETWEEN DateSerial(Year(Date()),Month(Date())-12,1)
AND DateSerial(Year(Date()),Month(Date())+1,0)
 
Thanks for the function.where to specify the function and
how to pass the column name to evaluate

subbu
 
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(...
 
Back
Top