Help With Date Calculation please

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Box666 - 29 Nov 2006 17:55 GMT

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.

Reply to this Message

Douglas J. Steele - 29 Nov 2006 18:02 GMT

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

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>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
[quoted text clipped - 5 lines]
>
> Can anybody help with a formula please.

Reply to this Message