Difference between revisions of "Date Comparisons"
From AgileApps Support Wiki
imported>Aeric (Created page with "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 || Ne...") |
imported>Aeric |
||
Line 3: | Line 3: | ||
:{| | :{| | ||
| This Month || 365 Days Ago || Next 7 Days || 120 Days Later | | This Month || 365 Days Ago || Next 7 Days || 120 Days Later | ||
|- | |||
| Today || 180 Days Ago || Next 14 Days || Current Yr | | Today || 180 Days Ago || Next 14 Days || Current Yr | ||
|- | |||
| Tomorrow || 120 Days Ago || Next 30 Days || Current & Next Yr | | Tomorrow || 120 Days Ago || Next 30 Days || Current & Next Yr | ||
|- | |||
| Yesterday || 90 Days Ago || Next 60 Days || Current & Previous Yr | | Yesterday || 90 Days Ago || Next 60 Days || Current & Previous Yr | ||
|- | |||
| Last Month || 60 Days Ago || Next 90 Days || Next Year | | Last Month || 60 Days Ago || Next 90 Days || Next Year | ||
|- | |||
| Last 365 Days || 30 Days Ago || Next 120 Days || Previous Year | | Last 365 Days || 30 Days Ago || Next 120 Days || Previous Year | ||
|- | |||
| Last 180 Days || 14 Days Ago || Today or After Today || rowspan="6"| | | Last 180 Days || 14 Days Ago || Today or After Today || rowspan="6"| | ||
|- | |||
| Last 120 Days || 7 Days Ago || After Today | | Last 120 Days || 7 Days Ago || After Today | ||
|- | |||
| Last 90 Days || Before Today || 7 Days Later | | Last 90 Days || Before Today || 7 Days Later | ||
|- | |||
| Last 30 Days || Today or Before Today || 30 Days Later | | Last 30 Days || Today or Before Today || 30 Days Later | ||
|- | |||
| Last 14 Days || Previous 12 months || 60 Days Later | | Last 14 Days || Previous 12 months || 60 Days Later | ||
|- | |||
| Last 7 Days || Next Month || 90 Days Later | | Last 7 Days || Next Month || 90 Days Later | ||
|} | |} |
Revision as of 20:34, 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