Date query

  • Thread starter Thread starter Dudley
  • Start date Start date
D

Dudley

Is it possible to create a query field which will yield the last day of the
month in the year following a specified date? For example if the date is
(British style) 25/10/2009, I would like 31 October 2010.

Thanks for any help.
Dudley
 
Is it possible to create a query field which will yield the last day of
the month in the year following a specified date? For example if the
date is (British style) 25/10/2009, I would like 31 October 2010.

Thanks for any help.
Dudley
Click to expand...

DateSerial(Year(YourSpecifiedDate)+1, Month(YourSpecifiedDate)+1,0)
 
Is it possible to create a query field which will yield the last day of the
month in the year following a specified date? For example if the date is
(British style) 25/10/2009, I would like 31 October 2010.

Thanks for any help.
Dudley
Click to expand...

Yes:

DateSerial(Year([specifieddate]), Month([specifieddate]) + 1, 0)

The zeroth day of next month is the last day of this month...
 
Just what I need. Thanks very much to Rick and John.
Dudley

John W. Vinson said:
Is it possible to create a query field which will yield the last day of the
month in the year following a specified date? For example if the date is
(British style) 25/10/2009, I would like 31 October 2010.

Thanks for any help.
Dudley
Click to expand...

Yes:

DateSerial(Year([specifieddate]), Month([specifieddate]) + 1, 0)

The zeroth day of next month is the last day of this month...
Click to expand...
 
Back
Top