Skip to main content
Question

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

  • August 15, 2023
  • 0 replies
  • 111 views

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
------------------------------
    This topic has been closed for replies.

    • AhuvaBrown
    • Registered
    • August 15, 2023

    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
    ------------------------------
      Terms & ConditionsAccessibility statement