Forum Discussion

ChrisFaye1's avatar
ChrisFaye1
Qrew Cadet
3 years ago

Static Future Date Formula

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
------------------------------
Formulas and functions
  • KarahWeber's avatar
    KarahWeber
    Qrew Member
    3 years ago
    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
    ------------------------------