Forum Discussion

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
------------------------------
No RepliesBe the first to reply