Forum Discussion

BenjaminBrooks's avatar
BenjaminBrooks
Qrew Trainee
5 years ago

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 have used a date formula type but having trouble figuring out the formula to make this happen.

------------------------------
Benjamin Brooks
------------------------------
  • np, 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
    ------------------------------