Page History
...
Based on Run Date (Column designer screen) | Based on As Of Date (Report Settings screen) | ||||
---|---|---|---|---|---|
Start/End Offset | Description | Start Date | End Date | Start Date | End Date |
BOT | Beginning of Time | 1/1/1900 | - | 1/1/1900 | - |
BOY | Beginning of Year | 1/1/2016 | - | 1/1/2015 | - |
BOY-1yr | Beginning of Year minus 1 yr | 1/1/2015 | - | 1/1/2014 | - |
BOY-2yr | Beginning of Year minus 2 yrs | 1/1/2014 | - | 1/1/2013 | - |
BOY-3yr | Beginning of Year minus 3 yrs | 1/1/2013 | - | 1/1/2012 | - |
BOY-4yr | Beginning of Year minus 4 yrs | 1/1/2012 | - | 1/1/2011 | - |
BOY-5yr | Beginning of Year minus 5 yrs | 1/1/2011 | - | 1/1/2010 | - |
EOY | End of Year | - | 12/31/2016 | - | 12/31/2015 |
EOY-1yr | End of Year minus 1 yr | - | 12/31/2015 | - | 12/31/2014 |
EOY-2yr | End of Year minus 2 yrs | - | 12/31/2014 | - | 12/31/2013 |
EOY-3yr | End of Year minus 3 yrs | - | 12/31/2013 | - | 12/31/2012 |
EOY-4yr | End of Year minus 4 yrs | - | 12/31/2012 | - | 12/31/2011 |
EOY-5yr | End of Year minus 5 yrs | - | 12/31/2011 | - | 12/31/2010 |
Custom | Defaulted to Today's date. You can define specific date here. | 1/26/2016 | 1/26/2016 | 12/31/2015 | 12/31/2015 |
0 | Current Month | 1/1/2016 | 1/31/2016 | 12/1/2015 | 12/31/2015 |
1 | Current Month plus 1 month | 2/1/2016 | 2/29/2016 | 1/1/2016 | 1/31/2016 |
2 | Current Month plus 2 months | 3/1/2016 | 3/31/2016 | 2/1/2016 | 2/29/2016 |
3 | Current Month plus 3 months | 4/1/2016 | 4/30/2016 | 3/1/2016 | 3/31/2016 |
4 | Current Month plus 4 months | 5/1/2016 | 5/31/2016 | 4/1/2016 | 4/30/2016 |
5 | Current Month plus 5 months | 6/1/2016 | 6/30/2016 | 5/1/2016 | 5/31/2016 |
6 | Current Month plus 6 months | 7/1/2016 | 7/31/2016 | 6/1/2016 | 6/30/2016 |
7 | Current Month plus 7 months | 8/1/2016 | 8/31/2016 | 7/1/2016 | 7/31/2016 |
8 | Current Month plus 8 months | 9/1/2016 | 9/30/2016 | 8/1/2016 | 8/31/2016 |
9 | Current Month plus 9 months | 10/1/2016 | 10/31/2016 | 9/1/2016 | 9/30/2016 |
10 | Current Month plus 10 months | 11/1/2016 | 11/30/2016 | 10/1/2016 | 10/31/2016 |
11 | Current Month plus 11 months | 12/1/2016 | 12/31/2016 | 11/1/2016 | 11/30/2016 |
12 | Current Month plus 12 months | 1/1/2017 | 1/31/2017 | 12/1/2016 | 12/31/2016 |
24 | Current Month plus 24 months | 1/1/2018 | 1/31/2018 | 12/1/2017 | 12/31/2017 |
-1 | Current Month minus 1 month | 12/1/2015 | 12/31/2015 | 11/1/2015 | 11/30/2015 |
-2 | Current Month minus 2 months | 11/1/2015 | 11/30/2015 | 10/1/2015 | 10/31/2015 |
-3 | Current Month minus 3 months | 10/1/2015 | 10/31/2015 | 9/1/2015 | 9/30/2015 |
-4 | Current Month minus 4 months | 9/1/2015 | 9/30/2015 | 8/1/2015 | 8/31/2015 |
-5 | Current Month minus 5 months | 8/1/2015 | 8/31/2015 | 7/1/2015 | 7/31/2015 |
-6 | Current Month minus 6 months | 7/1/2015 | 7/31/2015 | 6/1/2015 | 6/30/2015 |
-7 | Current Month minus 7 months | 6/1/2015 | 6/30/2015 | 5/1/2015 | 5/31/2015 |
-8 | Current Month minus 8 months | 5/1/2015 | 5/31/2015 | 4/1/2015 | 4/30/2015 |
-9 | Current Month minus 9 months | 4/1/2015 | 4/30/2015 | 3/1/2015 | 3/31/2015 |
-10 | Current Month minus 10 months | 3/1/2015 | 3/31/2015 | 2/1/2015 | 2/28/2015 |
-11 | Current Month minus 11 months | 2/1/2015 | 2/28/2015 | 1/1/2015 | 1/31/2015 |
-12 | Current Month minus 12 months | 1/1/2015 | 1/31/2015 | 12/1/2014 | 12/31/2014 |
-24 | Current Month minus 24 months | 1/1/2014 | 1/31/2014 | 12/1/2013 | 12/31/2012014 |
Expand | ||
---|---|---|
| ||
There are columns that require date filter and this page will help you understand how date filter works and how you should use it.
|
...
Overview
Content Tools