Last Day of the Month

[Kay]

Why am I working on a Friday night? Alas. This can't be too hard but my brain has petrified - like wood, not fraidy cats!

User inputs a booking date in field BookingDate. I would like a calculation to default the InvoiceDate to the last date of the month. So I pull the month out of the BookingDate and of course no "last day of" command. How about find first date of next month, then subtract a day? Good idea, but how to find first date of next month?

Any ideas? You would have my forever gratitude!

Kay

[MoonShadow]

Hi Kay,

Date(Month(BookingDate)+1, Day(1)-1, Year(BookingDate))

Go home.

[Kay]

Mercy! Thanks MoonShadow. And yes, I will ;-)

[bruceR]

Actually it's even simpler:

Date(Month(BookingDate)+1, 0, Year(BookingDate))

Day 0 of any month is the last day of the prior month.

[MoonShadow]

I knew this would work also:

Date(Month(BookingDate)+1, Day(1), Year(BookingDate)) -1

But your suggestion is eloquent indeed. Thank you for the valuable lesson.