Skip to main content
Question

Calculate Next Due Date based on End of Quarter

  • October 14, 2021
  • 0 replies
  • 68 views

Forum|alt.badge.img+5
How do I calculate a next quarter due date based on last day of quarter?

Quarter End Dates:
03/31
06/30
09/30
12/31

Thank you.

------------------------------
Sandralee Oster
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+5
  • Author
  • Quickbase Alumni
  • October 15, 2021
To clarify what I am trying to do.

I have a previous due date and I have a next quarter due date.  What I need to do is if the Previous due date is 03/31/2021 then the next quarter due date needs to be 06/30/2021.  This formula works up until I put a future date like 01/01/2022 and then it returns blank.

//Calculate the quarter end dates

If(
[Previous Quarter Date]<(ToDate("3/31/" & (Year(Today())))),ToDate("3/31/" & Year(Today())),
[Previous Quarter Date]<(ToDate("6/30/" & (Year(Today())))),ToDate("6/30/" & Year(Today())),
[Previous Quarter Date]<(ToDate("9/30/" & (Year(Today())))),ToDate("9/30/" & Year(Today())),
[Previous Quarter Date]<(ToDate("12/31/" & (Year(Today())))),ToDate("12/31/" & Year(Today()))

------------------------------
Sandralee Oster
------------------------------