Differences

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

--- master:date_tester [2020/06/16 23:47] – [Date Examples] Scott Cunliffe
+++ master:date_tester [2025/01/21 22:07] (current) – external edit 127.0.0.1
@@ Line 14: / Line 14: @@
 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 variables that us relative values such as Y-1 which will give you a corresponding date of last year.
+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 38: / Line 61: @@
 {{master_date_tester_4.png}}
+January 1st 2020 to end of last month
+''2020:m+''
+{{master_date_tester_5.png}}