adding a day to a date

erickp over 6 years ago

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?

Discussion posts and replies are publicly visible

Top Replies

Colton Beck over 6 years ago +1

Have you tried today()+1? This should handle the case you describe.

Parents

0 sikhivahans over 6 years ago

@erickp fn!eomonth() is one of the ways to determine if the date you are working on with is the last day in that particular month or not. For instance, to derive the current month's last day, use fn!eomonth(fn!today(),0) and similarly you can know the last day of a month of a given date.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel

Reply

0 sikhivahans over 6 years ago

@erickp fn!eomonth() is one of the ways to determine if the date you are working on with is the last day in that particular month or not. For instance, to derive the current month's last day, use fn!eomonth(fn!today(),0) and similarly you can know the last day of a month of a given date.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel

Children

No Data