====== 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'' {{master_date_tester_select.png}} ===== 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'' {{master_date_tester_1.png}} January 1st 2018 to December 31st 2019. ''2018:2019'' {{master_date_tester_2.png}} July 1st 2018 to June 30th 2020 ''2018-07-01:2019-06-30'' {{master_date_tester_3.png}} January 1st 2020 to end of current month ''2020:m+'' {{master_date_tester_4.png}} January 1st 2020 to end of last month ''2020:m+'' {{master_date_tester_5.png}}