master:date_tester
This is an old revision of the document!
Table of Contents
Date Tester
Date Format Tester allows you to enter a date, or range of dates to display the predicted range in a calendar format.
This gives you the ability to check the intended results are contained within the specified dates before any reports are created.
Open Date Format Tester
Date Range
Dates can be entered in several formats, using a single year or a range of dates to span between.
Dates can also be entered as specified dates, such as 2019, or using relative values such as Y-1 which will give you a corresponding date of last year.
Syntax
Syntax | Description |
---|---|
YYYY-MM-DD | ISO Date Format |
* | Today |
W | This Week |
P | The oldest Date |
F | The most Future Date |
*±x | Today plus or minus number of days (x). |
M | The first day of this month |
m | The last day of this month. |
Y | The first day of the year. |
y | The last day of the year. |
M±x | The first day of the month plus or minus number of months (x). |
M±x±y | The first day of the month plus or minus number of months (x), plus or minus number of days (y). |
Y±x | The first day of the year plus or minus x months. |
Y±x±y | The first day of the year plus or minus number of years (x) plus or minus number of months (y). |
Y±x±y±z | The first day of the year plus or minus number of years (x) plus or minus number of months (y) plus or minus number of days (z). |
Date Examples
master/date_tester.1592353053.txt.gz · Last modified: 2025/01/21 22:07 (external edit)