Minimum Due Date Based on End of Quarter Date
Hello! I'm looking to create a date field formula that returns a due date that is 10 business days after a creation date field (this is auto populated based upon the recorded added date) or a stati...
Forum Discussion
The plan was to just populate a date in the [Quarter End Date] spot you outlined below and manually update that four times a year in this one date formula field. Will this work?
Also, in terms of setting up the variables this is something I haven't done before. Do I make the variables directly in the date formula field or is this something I'd have to do separately outside of that field and then reference? If this isn't an easy answer, if you could point me to any articles discussing it in the support pages that would be appreciated.
Again, thank you for your help!
------------------------------
Josh Baker
------------------------------
Also, in terms of setting up the variables this is something I haven't done before. Do I make the variables directly in the date formula field or is this something I'd have to do separately outside of that field and then reference? If this isn't an easy answer, if you could point me to any articles discussing it in the support pages that would be appreciated.
Again, thank you for your help!
------------------------------
Josh Baker
------------------------------
You can probably make [Quarter End Date] a field of its own maybe with:
If(
Today()<(ToDate("3/31/" & (Year(Today())))),ToDate("3/31/" & Year(Today())),
Today()<(ToDate("6/30/" & (Year(Today())))),ToDate("6/30/" & Year(Today())),
Today()<(ToDate("9/30/" & (Year(Today())))),ToDate("9/30/" & Year(Today())),
Today()<(ToDate("12/31/" & (Year(Today())))),ToDate("12/31/" & Year(Today()))
)
This also depends on if your quarter end dates are the same each year, but I noticed you used 7/31 as a quarter end date. i don't know if that was just for an example or if you use different days for that. There also might be an easier way to write that code above but that's what came to mind first.
------------------------------
Jordan McAlister
------------------------------
If(
Today()<(ToDate("3/31/" & (Year(Today())))),ToDate("3/31/" & Year(Today())),
Today()<(ToDate("6/30/" & (Year(Today())))),ToDate("6/30/" & Year(Today())),
Today()<(ToDate("9/30/" & (Year(Today())))),ToDate("9/30/" & Year(Today())),
Today()<(ToDate("12/31/" & (Year(Today())))),ToDate("12/31/" & Year(Today()))
)
This also depends on if your quarter end dates are the same each year, but I noticed you used 7/31 as a quarter end date. i don't know if that was just for an example or if you use different days for that. There also might be an easier way to write that code above but that's what came to mind first.
------------------------------
Jordan McAlister
------------------------------