Help With Date Calculation please

  • Thread starter Thread starter Box666
  • Start date Start date
B

Box666

I have a field that contains a date (say Dte_1) I would like to
introduce a calculated field that would give the date of the last day
of that month. So if

Dte_1= 11/11/2006 then new field would be 30/11/2006
Dte_1= 29/11/2006 then new field would be 30/11/2006
Dte_1= 1/02/2006 then new field would be 28/02/2006

Can anybody help with a formula please.
 
Assuming your other date is stored in TheOtherDate, you can use:

Dte_1 = DateSerial(Year(TheOtherDate), Month(TheOtherDate) + 1, 0)
 
Back
Top