Re: Date/Time Function
- From: "Jeff Boyce" <nonsense@xxxxxxxxxxxx>
- Date: Thu, 21 Dec 2006 09:40:42 -0800
When you say "convert", I assume you mean "calculate", since literally
converting February 16, 2006 to February 28, 2006 would lose the original
information (the 16th).
In a query, use the DateSerial() function to calculate EOM, with something
The "0"-th day of a month is the last day of the previous month. By adding
+1 to the indicated month first, you are pushing into the next month, then
using "0"-th day to back up to the last day of the indicated month.
Microsoft Office/Access MVP
"Wigberto" <Wigberto@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
Is there a function in Access equivalete to the "EoMonth" function in
I want to convert date in the specific field to the end of month. For
example, if the date in one field is Feb 16, 2006, I would like to convert
that date to the end of the month (Feb 28, 2006), (March 31, XXXX for a
falling within the month of March).