Primary and secondary arguments
Primary argument | Description |
|---|---|
&DATETIME | Relative filter on the current (system) date-time. Can be used in date-time fields and in date fields. Rounding of time: You can round the start and end time using the following secondary macros: &R15, &R30, &R60. &R15 - rounds to the nearest 15, 30, 45, 00 hours. &R30 - rounds to the nearest 30 and 00 hours &R60 - rounds to the nearest 00 hours. Example: If the current time is 11:36 hrs, see how the time is rounded off using the macro(s): &datetime &h1 &R15 - the time is rounded to 12:45. &datetime &h1 &R30 - the time is rounded off to 13:00. &datetime &h1 &R30 - the time is rounded off to 13:00. |
&TIME | Relative filter on the current (system) time. Can be used on time fields. For example, Visitor's arrival/departure time. You can round the start and end time using the following secondary macros: &Time &R15 : rounds to the nearest 15, 30, 45, 00 hours. &Time &R30 - rounds to the nearest 30 and 00 hours &Time &R60 - rounds to the nearest 00 hours. Example: If the current time is 11:58 hrs, see how the time is rounded off using the macro(s): &Time &R15 - rounds off to 12:00 hrs. &Time &R30 - rounds off to 12:00 hrs. &Time &R60 - rounds off to 12:00 hrs. |
&STARTOFDAY | Relative filter on the current (system) date (assumes time = 00:00). Can be used in date-time fields and in date fields. |
&ENDOFDAY | Relative filter on the current (system) date (assumes time = 23:59). Can be used in date-time fields and in time fields. |
&REFERENCEDATE | Relative filter on the current reference date. |
Secondary argument | Description |
|---|---|
&Y (or: &YEAR) | Relative filter for defining a period in years. |
&M (or: &Month) | Relative filter for defining a period in months. |
&W (or: &WEEK) | Relative filter for defining a period in weeks. |
&D (or: &DAY) | Relative filter for defining a period in days. |
&H (or: &Hour) | Relative filter for defining a period in hours. |
&N (or: &Minute) | Relative filter for defining a period in minutes. |
&Monday | Relative filter for defining a period in days following Monday in the week of the primary argument (= Monday before the primary argument.) |
&FirstOfMonth | The first day of the month of the primary argument. This relative filter can be used, for example, to filter out the orders of the current month. |
&FirstOfQuarter | The first day of the quarter of the primary argument. A filter on the first day/date of the current quarter of the current year preceded with &datetime primary argument. |
&FirstOfYear | A filter on the first day/date of the current year. This filter returns 1-1-THISYEAR when preceded with &datetime primary argument. |
Warning | Secondary arguments must be preceded by a primary argument. |
Examples of relative filters
• Visiting date = &Startofday: shows today's visitors
• Visiting date between &Startofday and &Startofday &D1: shows the visitors of today and tomorrow
• &Startofday &Monday3 (or &Startofday &Monday &D3) means Thursday (00:00 h) of the week in which the current day falls.
Note that a week starts on Monday, so if today is Sunday, this macro means last Thursday. If today is Monday, the macro means this Thursday.
Note that a week starts on Monday, so if today is Sunday, this macro means last Thursday. If today is Monday, the macro means this Thursday.
• &Startofday &FirstOfMonth-1 (or &Startofday &FirstOfMonth &D-1) means the last day of the previous month.
• &Startofday &FirstOfMonth9 (or &Startofday &FirstOfMonth &D9) means the 10th day of the current month.
Below is an example of a relative filter set on the Visiting Date field of a visitor.
• &datetime &Firstofquarter : shows October 1, 2018 when executed in Q4 2018.
• &datetime &Firstofyear: shows January 1, 2018 when executed in Q4 2018.
Warning | Macros cannot be used in combination with fixed dates! So, a relative filter that includes an actual date will result in an error. |