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
From the main menu in TapeMaster, select Tools > Date 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 literal dates, such as 2019, or using date calculation variables such as Y-1 which will give you a corresponding date of last year.
Date Calculation Variables
Variable Syntax
| Syntax | Description |
|---|---|
| YYYY-MM-DD | ISO Date Format |
| * | Today |
| W | Start of the Week |
| P | The oldest date |
| F | The most future date |
| M | The first day of the month |
| m | The last day of the month. |
| Y | The first day of the year. |
| y | The last day of the year. |
Variable Syntax Examples
| Syntax | Description |
|---|---|
| Y-1:y-1 | January 1st to December 31st last year |
| M-1:m-1 | 1st of last month to the last day of last month |
| W-2:* | 2 weeks ago until today |
Date Examples
January 1st to December 31st 2019.
2019
January 1st 2018 to December 31st 2019.
2018:2019
July 1st 2018 to June 30th 2020
2018-07-01:2019-06-30
January 1st 2020 to end of current month
2020:m+
January 1st 2020 to end of last month
2020:m+
