Calculate the date 6 months old from today

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

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

Hi Miguel Garcia-Gonzalez

eomonth() function only returns the last day of the month but not the exact date minus number of months

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.

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

It can be simplified even more by using the built in function edate()

docs.appian.com/.../fnc_date_and_time_edate.html