Date time, Leap year

[DiyaR]

Hi, 

Last year was a leap year. In my current work flow, my formula below is going back a year and gives me output "2020-02-28" obviously didn't considered leap year.   

DateTimeAdd(DateTimeTrim([Max_Date],'lastofmonth'),-1,"Years")

My [Max date]= 2021-02-28

what can I do make my output show me "2020-02-29"??

Appreciate your expertise 🙂

thank u 😉

[Luke_C · Accepted solution]

Try moving the datetime trim in your formula:

datetimetrim(datetimeadd([Max_Date],-1,'years'),'lastofmonth')

[DiyaR]

Thank you, Luke. It worked. Much appreciated!