Skip to main content
Question

Static Future Date Formula

  • January 6, 2022
  • 0 replies
  • 66 views
Hi! 

Date formulas always get me. 

Here's what I'm trying to do:
If ([Paid Date] + Days(15)) is on or before the 15th of the month, set the date to that month/day 15/year.
If ([Paid Date] + Days(15)) is after the 15th of the month, set the date to the upcoming month/day 1/year.

Really just looking to add 15 days to the paid date and then set to the next pay date either the next 1st or 15th.

Any help would be amazing!

Thank You!

------------------------------
Chris
------------------------------
This topic has been closed for replies.

  • KarahWeber
  • Registered
  • January 6, 2022
Hi Chris,

Go into your fields, set field type to Formula (Date), and enter the following formula. 

If((Day([Date Paid]+Days(15)))<= 15, ((FirstDayOfMonth(([Date Paid]+Days(15))))+Days(14)), FirstDayOfMonth((AdjustMonth(([Date Paid]+Days(15)),+1))))


Where Date Paid is the date they paid it, and Date Due is the date the payment is due. 
Hope this helped!

------------------------------
Karah Weber
------------------------------
Terms & ConditionsAccessibility statement