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
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
| Syntax | Description |
|---|---|
| YYYY-MM-DD | ISO Date Format |
| * | Today |
| W | This Week |
| P | The oldest Date |
| F | The most Future Date |
| 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. |
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+
