If then else with DATE

Ask for Help
18

@Food2Soil - here, I think this is a better approach…

The math formulas used:

  • To add an arbitrary number of months to a date:
((Now-DAY(Now)+15)+(Years/12*365.25))
-
DAY((Now-DAY(Now)+15)+(Years/12*365.25))
+
DAY(Now)
  • To get midnight on the first day of the month from a given date:
Date+1-Day(Date)-Hour(Date)/24-Minute(Date)/1440-Second(Date)/86400
5 Likes