Calculate the date 6 months old from today

Question

Calculate the date 6 months old from today, please advise with recipes

omere0001 · Accepted Answer

Here is a code snippet that will return 6 months from the previous day. It also takes into account years, so 6 months ago from January will return July of the previous year. I also added error handling for if the day of the month is greater than the number of days in the previous month (i.e no February 31st). In that scenario it will just return the last day of the month. 
 
date( 
 year(eomonth(today(), -6)), 
 month(eomonth(today(), -6)), 
 day( 
 if( 
 day(today()) > daysinmonth(month(eomonth(today(), -6)), year(eomonth(today(), -6))), 
 eomonth(today(), -6), 
 today() 
 ) 
 ) 
) 
 
Just replace all of the -6 with however many months back you want.

malavikak0001 · Answer

I think I found the answer, plugin called Date and Time Functions has some called subtractmonths(now(), 6)

Miguel Garcia-Gonzalez · Answer

You can use a date function provided by Appian called eomonth(), I think it does what you are asking for. 
 
Please refer to: docs.appian.com/.../fnc_date_and_time_eomonth.html

Hrishikesh Dixit · Answer

This can be simplified as follows - 
 if(
 and(eomonth(ri!inputDate, 0) = ri!inputDate, month(ri!inputDate) <> 2),
 eomonth(ri!inputDate, -ri!numOfmonthsBack),
 eomonth(ri!inputDate, - (ri!numOfmonthsBack+1)) + day(ri!inputDate)
) 
 
 FYI this website is useful for validation 
 https://www.timeanddate.com/date/dateadd.html

Calculate the date 6 months old from today

Top Replies