Difference between revisions of "Date Comparisons"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
Line 1: Line 1:
When comparing a date value in a [[Rule]] or [[Decision Switch]], there is a wide array of date-ranges that can be evaluated:
When comparing a date value in a [[Rule]] or [[Decision Switch]], there is a wide array of date-ranges that can be evaluated:


:{| cellspacing="10"
:{| cellpadding="3" class="tight-rows"
| This Month    || 365 Days Ago          || Next 7 Days          || 120 Days Later
| This Month    || 365 Days Ago          || Next 7 Days          || 120 Days Later
|-
|-

Revision as of 20:36, 5 September 2014

When comparing a date value in a Rule or Decision Switch, there is a wide array of date-ranges that can be evaluated:

This Month 365 Days Ago Next 7 Days 120 Days Later
Today 180 Days Ago Next 14 Days Current Yr
Tomorrow 120 Days Ago Next 30 Days Current & Next Yr
Yesterday 90 Days Ago Next 60 Days Current & Previous Yr
Last Month 60 Days Ago Next 90 Days Next Year
Last 365 Days 30 Days Ago Next 120 Days Previous Year
Last 180 Days 14 Days Ago Today or After Today  
Last 120 Days 7 Days Ago After Today
Last 90 Days Before Today 7 Days Later
Last 30 Days Today or Before Today 30 Days Later
Last 14 Days Previous 12 months 60 Days Later
Last 7 Days Next Month 90 Days Later