JordanMcAliste1
5 years agoQrew Member
Re: Minimum Due Date Based on End of Quarter Date
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
------------------------------