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 😉
Solved! Go to Solution.
Try moving the datetime trim in your formula:
datetimetrim(datetimeadd([Max_Date],-1,'years'),'lastofmonth')
Thank you, Luke. It worked. Much appreciated!