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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to find out the last inserted row in Access 2
How to give group by in the select query 2
Error while inserting null data in Append Query 1
How to update Rows 1
How to update the table 1
Either BOF OR EOF is True Error 1
How to give specify dates as criteria in Select query 4
Funcation to average the Time spent 1

Back
Top