Calculate the date 6 months old from today, please advise with recipes
Discussion posts and replies are publicly visible
This can be simplified as follows -
and(eomonth(ri!inputDate, 0) = ri!inputDate, month(ri!inputDate) <> 2),
eomonth(ri!inputDate, - (ri!numOfmonthsBack+1)) + day(ri!inputDate)
FYI this website is useful for validation
It can be simplified even more by using the built in function edate()
Thank you so much for giving this quite useful knowledge.
© 2022 Appian. All rights reserved.