Skip to main content
Solved

How to get Last day of current month

  • October 11, 2023
  • 1 reply
  • 60 views
A
Data Voyager
Forum|alt.badge.img+1

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

Best answer by AKislyakov

Hi @anagha.k,

 

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

 

 

View original
Did this topic help you find an answer to your question?

1 reply

A
Ataccamer
Forum|alt.badge.img+2
  • AKislyakovAtaccamer
  • Ataccamer
  • 148 replies
  • Answer
  • October 12, 2023

Hi @anagha.k,

 

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

 

 

Cansu
1 person likes this
  • Cansu
    Cansu

Reply


Most Liked this week

Community Terms of Use & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings