Another Access Function for Dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
You might use an expression something like this:

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


Kirk P. said:
Is there a function that will examine the "Date" field and return the last
Click to expand...
day of the month for the Date indicated? For example:
 
Back
Top