Creating the AskPlus Macro File - Revision history

Johno: /* Using the Visimage3 Admin Menu to Maintain Usermdef */

2023-06-05T19:54:13Z

‎Using the Visimage3 Admin Menu to Maintain Usermdef

Johno at 18:13, 20 January 2023

2023-01-20T18:13:57Z

Johno: /* Macros Affected by DFTL-HR-OFFSET */

2023-01-20T17:29:12Z

‎Macros Affected by DFTL-HR-OFFSET

Johno: /* %DFLT-HR-OFFSET */

2022-11-29T23:24:21Z

‎%DFLT-HR-OFFSET

Johno: /* %DFLT-HR-OFFSET */

2022-11-29T22:40:17Z

‎%DFLT-HR-OFFSET

>Johno: /* %DFLT-HR-OFFSET */

2020-07-14T23:09:53Z

‎%DFLT-HR-OFFSET

>Johno: /* Macros Affected by DFTL-HR-OFFSET */

2020-07-14T23:06:13Z

‎Macros Affected by DFTL-HR-OFFSET

>Johno: /* Macros Affected by DFTL-HR-OFFSET */

2020-07-14T23:05:19Z

‎Macros Affected by DFTL-HR-OFFSET

>Johno: /* Macros Affected by DFTL-HR-OFFSET */

2020-07-14T23:04:21Z

‎Macros Affected by DFTL-HR-OFFSET

>Johno at 22:47, 14 July 2020

2020-07-14T22:47:26Z

@@ Line 76: / Line 76: @@
 === Using the Visimage3 Admin Menu to Maintain Usermdef ===
-By default Fiserv Saas clients will be able to use the Admin menu to maintain their usermdef file. In-house clients will need to make the following changes if they wish to use the Visimage3 Admin menu to maintain usermdef.
+By default Fiserv SaaS clients will be able to use the Admin menu to maintain their usermdef file. In-house clients will need to make the following changes if they wish to use the Visimage3 Admin menu to maintain usermdef.
 *Grant Admin access to the Visimage3 user (Admin = Y in their vsrvtcp.ini profile)
 *The usermdef file must be copied to one of two locations. Either:

@@ Line 1: / Line 1: @@
 AskPlus macros are an easy way to save commonly used calculations.  When macros are used, the definition of the macro is expanded and the definition is used as though it had been typed.  Macros may contain parameters.
@@ Line 18: / Line 19: @@
 === Accessing a Macro File ===
 To be used by Visimage3 or AskPlus, the macro definitions must be '''''loaded''''' into a macro file.  Once created, the macro file must be referenced either by the AskPlus ''assign macro'' command, or in a Visimage Manager File ''Macro'' statement.
 === Creating the Macro File ===
@@ Line 65: / Line 74: @@
 fname - Is the name of the macro file to be created.
 </pre>
 === %DFLT-HR-OFFSET ===

@@ Line 77: / Line 77: @@
 ==== Macros Affected by DFTL-HR-OFFSET ====
-In the table which follows, "current", "prior" and "next" are all dtermined by the current system date, less the number of hours specified in the DFLT-HR-OFFSET macro.  If ASK_REFDATE has been set, then "current", "prior" and "next" are determined by the value of [[Setting the Logical Date|ASK_REFDATE]].
+In the table which follows, "current", "prior" and "next" are all determined by the current system date, less the number of hours specified in the DFLT-HR-OFFSET macro.  If ASK_REFDATE has been set, then "current", "prior" and "next" are determined by the value of [[Setting the Logical Date|ASK_REFDATE]].
      {| class="wikitable" style="border-spacing: 2,2,2,2;"
       |Macro Name||Description.

@@ Line 69: / Line 69: @@
 This macro sets a default time offset in hours which is used by some date macros, like CYMD-TODAY and CYMD-YESTERDAY.  The macro allows reports run early in the morning to use the previous day's date as the "current" date.  By default, the value is 6 hours, meaning that jobs which are run prior to 6 am will behave as though they were run before midnight.
 <pre>
-macro DFLT-HR-OFFSET = !IIF((6 * 3600) splice "|" splice 0,
+macro DFLT-HR-OFFSET = !IIF((6 * 3600) splice "|" splice 0, &
                         (!datext($SECONDS, "cymd") = (($YEAR * 10000) + ($MONTH * 100) + $MONTHDAY)))
 </pre>

@@ Line 69: / Line 69: @@
 This macro sets a default time offset in hours which is used by some date macros, like CYMD-TODAY and CYMD-YESTERDAY.  The macro allows reports run early in the morning to use the previous day's date as the "current" date.  By default, the value is 6 hours, meaning that jobs which are run prior to 6 am will behave as though they were run before midnight.
 <pre>
-macro DFLT-HR-OFFSET = !IIF((6 * 3600) splice "|" splice 0, (!datext($SECONDS, "cymd") = (($YEAR * 10000) + ($MONTH * 100) + $MONTHDAY)))
+macro DFLT-HR-OFFSET = !IIF((6 * 3600) splice "|" splice 0,
 </pre>
 * The !IIF logic shown above ensures that the offset will be ignored when [[Setting the Logical Date|ASK_REFDATE]] is set.

@@ Line 80: / Line 80: @@
       |Macro Name||Description.
       |-
-      | CTMD-TODAY || Returns the "current" day in CYMD format.
+      | CYMD-TODAY || Returns the "current" day in CYMD format.
       |-
-      | CTMD-YESTERDAY || Returns the "previous" day in CYMD format.
+      | CYMD-YESTERDAY || Returns the "prior" day in CYMD format.
       |-
       | FDAY-CUR-MO & LDAY-CUR-MO || Returns the first/last day of the "current" month in CYMD format.

@@ Line 76: / Line 76: @@
 ==== Macros Affected by DFTL-HR-OFFSET ====
-In the table which follows, "current", "previous" and "next" are all dtermined by the current system date, less the number of hours specified in the DFLT-HR-OFFSET macro.  If ASK_REFDATE has been set, then "current", "previous" and "next" are determined by the value of ASK_REFDATE.
+In the table which follows, "current", "prior" and "next" are all dtermined by the current system date, less the number of hours specified in the DFLT-HR-OFFSET macro.  If ASK_REFDATE has been set, then "current", "prior" and "next" are determined by the value of ASK_REFDATE.
      {| class="wikitable" style="border-spacing: 2,2,2,2;"
       |Macro Name||Description.
@@ Line 86: / Line 86: @@
       | FDAY-CUR-MO & LDAY-CUR-MO || Returns the first/last day of the "current" month in CYMD format.
       |-
-      | FDAY-PRI-MO & LDAY-PRI-MO || Returns the first/last day of the "previous" month in CYMD format.
+      | FDAY-PRI-MO & LDAY-PRI-MO || Returns the first/last day of the "prior" month in CYMD format.
       |-
       | FDAY-NXT-MO & LDAY-NXT-MO || Returns the first/last day of the "next" month in CYMD format.
@@ Line 92: / Line 92: @@
       | FDAY-CUR-WK & LDAY-CUR-WK || Returns the first/last day of the "current" week in CYMD format.
       |-
-      | FDAY-PRI-WK & LDAY-PRI-WK || Returns the first/last day of the "previous" week in CYMD format.
+      | FDAY-PRI-WK & LDAY-PRI-WK || Returns the first/last day of the "prior" week in CYMD format.
       |-
       | FDAY-NXT-WK & LDAY-NXT-WK || Returns the first/last day of the "next" week in CYMD format.
@@ Line 98: / Line 98: @@
       | LOAD-DATES-CUR-WK || Loads an array with the 7 days in the "current" week in CYMD format.
       |-
-      | LOAD-DATES-PRI-WK || Loads an array with the 7 days in the "previous" week in CYMD format.
+      | LOAD-DATES-PRI-WK || Loads an array with the 7 days in the "prior" week in CYMD format.
       |-
       | LOAD-DATES-NXT-WK || Loads an array with the 7 days in the "next" week in CYMD format.
       |}

← Older revision		Revision as of 23:04, 14 July 2020
Line 76:		Line 76:

	==== Macros Affected by DFTL-HR-OFFSET ====		==== Macros Affected by DFTL-HR-OFFSET ====
		+	In the table which follows, "current", "previous" and "next" are all dtermined by the current system date, less the number of hours specified in the DFLT-HR-OFFSET macro. If ASK_REFDATE has been set, then "current", "previous" and "next" are determined by the value of ASK_REFDATE.
		+	{\| class="wikitable" style="border-spacing: 2,2,2,2;"
		+	\|Macro Name\|\|Description.
		+	\|-
		+	\| CTMD-TODAY \|\| Returns the "current" day in CYMD format.
		+	\|-
		+	\| CTMD-YESTERDAY \|\| Returns the "previous" day in CYMD format.
		+	\|-
		+	\| FDAY-CUR-MO & LDAY-CUR-MO \|\| Returns the first/last day of the "current" month in CYMD format.
		+	\|-
		+	\| FDAY-PRI-MO & LDAY-PRI-MO \|\| Returns the first/last day of the "previous" month in CYMD format.
		+	\|-
		+	\| FDAY-NXT-MO & LDAY-NXT-MO \|\| Returns the first/last day of the "next" month in CYMD format.
		+	\|-
		+	\| FDAY-CUR-WK & LDAY-CUR-WK \|\| Returns the first/last day of the "current" week in CYMD format.
		+	\|-
		+	\| FDAY-PRI-WK & LDAY-PRI-WK \|\| Returns the first/last day of the "previous" week in CYMD format.
		+	\|-
		+	\| FDAY-NXT-WK & LDAY-NXT-WK \|\| Returns the first/last day of the "next" week in CYMD format.
		+	\|-
		+	\| LOAD-DATES-CUR-WK \|\| Loads an array with the 7 days in the "current" week in CYMD format.
		+	\|-
		+	\| LOAD-DATES-PRI-WK \|\| Loads an array with the 7 days in the "previous" week in CYMD format.
		+	\|-
		+	\| LOAD-DATES-NXT-WK \|\| Loads an array with the 7 days in the "next" week in CYMD format.
		+	\|}

← Older revision		Revision as of 22:47, 14 July 2020
Line 75:		Line 75:
	* The value is actually a number of seconds. Since there are 3600 seconds in one hour, the offset is calculated as 6*3600.		* The value is actually a number of seconds. Since there are 3600 seconds in one hour, the offset is calculated as 6*3600.

−	~~+++ ASK_REFDATE~~ ===	+	==== Macros Affected by DFTL-HR-OFFSET ====