Another Access Function for Dates

[Guest]

Is there a function that will examine the "Date" field and return the last day of the month for the Date indicated? For example

Date EndDat
6/10/2003 6/30/200
7/5/2003 7/31/200
2/25/2003 2/28/200

 

[Brian Camire]

You might use an expression something like this:

DateSerial(Year([Your Date Field]), Month([Your Date Field]) + 1, 0)

Is there a function that will examine the "Date" field and return the last

day of the month for the Date indicated? For example: