Difference between revisions of "Standard field replacements"
From All n One's bxp software Wixi
Philip Lacey (talk | contribs) m |
Philip Lacey (talk | contribs) m |
||
| Line 15: | Line 15: | ||
== Overview == | == Overview == | ||
| + | |||
If you use the -- field replacement notation you can achieve dynamic opening scripts. | If you use the -- field replacement notation you can achieve dynamic opening scripts. | ||
| − | = Standard fields = | + | |
| + | = Replacements = | ||
| + | |||
| + | |||
| + | == Standard fields == | ||
* --period-- | * --period-- | ||
| Line 25: | Line 30: | ||
* --surname-- | * --surname-- | ||
| − | = Date Time fields = | + | |
| + | == Date Time fields == | ||
Latest revision as of 22:50, 13 March 2018
| The -- notation | Standard replacements | The -- notation for bxp forms | Special replacements |
|---|---|---|---|
| Link | Link | Link | Link |
1 Overview
If you use the -- field replacement notation you can achieve dynamic opening scripts.
2 Replacements
2.1 Standard fields
- --period--
- --firstname--
- --surname--
2.2 Date Time fields
--dteNow--
This will replace the current date and time into your report in universal date time format, e.g. 2015-01-01 00:00:00
--dteNowStart--
This will replace the current date of today with a time of 00:00:00 into your report in universal date time format, e.g. 2015-01-01 00:00:00
--dteNowEnd--
This will replace the current date of tomorrow with a time of 00:00:00 into your report in universal date time format, usually used with a less than, e.g. 2015-01-01 00:00:00
--dteNow+7d--
This will replace with seven days into the future with a time of 00:00:00 into your report in universal date time format, usually used with a less than, e.g. 2015-01-01 00:00:00
--dteNow-4w--
This will replace with four weeks into the past with a time of 00:00:00 into your report in universal date time format, usually used with a less than, e.g. 2015-01-01 00:00:00
For all the possible letter combinations please review http://www.w3schools.com/asp/func_dateadd.asp
