Differences

This shows you the differences between two versions of the page.

--- master:date_tester [2020/06/16 01:43] – created Scott Cunliffe
+++ master:date_tester [2025/01/21 22:07] (current) – external edit 127.0.0.1
@@ Line 3: / Line 3: @@
 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''
-{{img-menu}}
+{{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 ====
@@ Line 18: / Line 44: @@
 ''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}}