Forum Discussion

ChrisBaker2's avatar
ChrisBaker2
Qrew Member
10 months ago

Date field formula that is always the 10th of the next month of a given date.

QuickBase Support Center

I've looked at the formulas for dates above but couldn't find what I needed.

I need a read only formula field that will always be the 10th of the following month based on another date field.

Thanks.



------------------------------
Chris Baker
------------------------------

1 Reply

Sort By
  • AhuvaBrown's avatar
    AhuvaBrown
    Qrew Cadet
    10 months ago

    This should do it:

    FirstDayOfMonth(AdjustMonth([Date Field], 1)) + Days(9)

    AdjustMonth([Date Field], 1) returns the date one month from the date field.

    FirstDayOfMonth() returns the first day of the above month.

    + Days(9) adds 9 days to the first day of the month, returning the 10th day.

    I hope that works for you.



    ------------------------------
    Ahuva Brown
    ------------------------------