Discussions

Expand all | Collapse all

First day of next month formula

  • 1.  First day of next month formula

    Posted 16 days ago
    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
    ------------------------------


  • 2.  RE: First day of next month formula

    Posted 16 days ago
    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
    ------------------------------