Help With Date Calculation please

[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.

 

[Douglas J. Steele]

Assuming your other date is stored in TheOtherDate, you can use:

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