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] + ...
Forum Discussion
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
------------------------------
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
------------------------------