Convert date to last calendar date

[Mark Senibaldi]

Hi,

How can I convert a given date into the last date of that month? For
example: 5/15/2006 needs to be converted into 5/31/2006. 6/1/2007 needs to
be conveted into 6/30/2007.

Thanks.

 

[Allen Browne]

If the field is named Date1, this expression should give you the last day of
the month:

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

 

[Jeff Boyce]

Mark

This may seem a bit circuituous, but you can use the DateSerial() function
to find the day BEFORE the first day of NEXT month. The (untested) code
looks something like:

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

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Mark Senibaldi]

That solved my problem,

Thanks.
--
MSS

If the field is named Date1, this expression should give you the last day of
the month:

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

How can I convert a given date into the last date of that month? For
example: 5/15/2006 needs to be converted into 5/31/2006. 6/1/2007 needs
to
be conveted into 6/30/2007.

Thanks.

 

[Mark Senibaldi]

That solved my problem,

Thanks.
--
MSS

Mark

This may seem a bit circuituous, but you can use the DateSerial() function
to find the day BEFORE the first day of NEXT month. The (untested) code
looks something like:

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

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi,

How can I convert a given date into the last date of that month? For
example: 5/15/2006 needs to be converted into 5/31/2006. 6/1/2007 needs
to
be conveted into 6/30/2007.

Thanks.