find month end date base on today()

[BosKev]

Hi All,

is there a formula to always find the month end date base on today's date? Thanks.

I was trying something like below but syntax is not right.

DateTimeLastOfMonth((DateTimeToday(),1,"Days")) 

[RolandSchubert · Accepted solution]

Hi @BosKev ,

DateTimeLastOfMonth() should always return the last day of the current month.

Let me know if it works foryou.

Best,

Roland

[BosKev]

Thank you!