adding a day to a date

Question

What is the way to add a day to a date?

For example, when I do: datetime(year(today()), month(today()), day(today()) + 1, 13), it doesn't work for the case when today() = last day of the month. For example, yesterday was the last day of the month (the 31st) and we had an issue because 31 + 1 is 32 and that day doesn't exist. What is the way to add a day so that the system figures out by itself that August 31st + 1 is September 1st and not August 32nd?

baghavathit · Answer

For finding the next day, you can use todate() function. like: todate("some date")+1. Eg: todate("8/31/2016")+1 will obviously return Sept 1, not august 32.

ManuelHTG · Answer

if you want to do a date + day you should use the day() funtion 
 i.e. now() + 7*day() will give you today + 7 days. 
 Try with this: 
 https://docs.appian.com/suite/help/18.4/fnc_date_and_time_day.html

ManuelHTG · Answer

it is difficult to say what is wrong without knowing how you have set-up the CDT, how you have saved the data on the DB and which data is present there. 
 
I would first get the data "start" from the DB without filtering. Then create an expression rule to play with the data and make sure you are handling well the date fields.

Vincenzo Reggina · Answer

Simply works, still today.

adding a day to a date

Top Replies