Skip to main content

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

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


Community Terms of Use & ConditionsCookie settings