How to get Last day of current month

Hi,
I need to create one rule which is used to check whether last date of current month is available in that column or not. For that I need expression to get the last day of current month.

Note:

Today is 2023-10-11. So I need to get 2023-10-31.

or

if today is 2023-09-04 then I should get 2023-09-30 as output.

Can anyone provide a solution for this?

Thanks

Anagha K

Page 1 / 1

Hi @anagha.k,

You can use this expression to get last day of the months
dateAdd(dateTrunc(dateAdd(today(), 1, 'MONTH'), 'MONTH'), -1, 'DAY')

Reply

Sign up

Login to the Ataccama Community

Scanning file for viruses.

This file cannot be downloaded