First day of next month formula
I have a date sold and I would like to automate my effective date to be the 1st day of the next month. ie Date sold is 03/15/2020 i would like it to set the effective date as 4/1/2020 and so on. I hav...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp, try this
FirstDayOfMonth(AdjustMonth([Date Sold],1)
// AdjustMonth will adjust the date ahead to the same day "1" month ahead.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
FirstDayOfMonth(AdjustMonth([Date Sold],1)
// AdjustMonth will adjust the date ahead to the same day "1" month ahead.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------