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 have used a date formula type but having trouble figuring out the formula to make this happen.
------------------------------
Benjamin Brooks
------------------------------
Question
First day of next month formula
This topic has been closed for replies.
+24np, 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
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.