adding a day to a date

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?

OriginalPostID-232448

  Discussion posts and replies are publicly visible

Parents
  • @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.
Reply
  • @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.
Children
No Data