End of month function: same as Excel EOMONTH function

[Meneghino]

Please can we have this function?

It is very useful for calculating end of periods.

[Anonymous]

I found this work around, calculating current month's last day:

DateAdd(
    DateAdd(
        Date(Year(Today()), Month(Today()), 1),
        1,
        Months),
    -1,
    Days)

https://powerusers.microsoft.com/t5/General-Discussion/Set-Default-date-of-Date-Picker-to-first-and-...

[BrentITSS]

Brilliant - great stuff, thanks.