Difference between revisions of "Standard field replacements"
From All n One's bxp software Wixi
Philip Lacey (talk | contribs) (Created page with "If you use the -- field replacement notation you can achieve dynamic opening scripts. * --period-- * --firstname-- * --surname-- Category:Topic:Key Concept") |
Philip Lacey (talk | contribs) m |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | |||
| + | {| class="wikitable" style="width:100%;" | ||
| + | ! style="width:25%;text-align:center;" | The -- notation | ||
| + | ! style="width:25%;text-align:center;" | Standard replacements | ||
| + | ! style="width:25%;text-align:center;" | The -- notation for bxp forms | ||
| + | ! style="width:25%;text-align:center;" | Special replacements | ||
| + | |- | ||
| + | | style="text-align:center;" | [[The_--_field_notation|Link]] | ||
| + | | style="text-align:center;" | [[Standard_field_replacements|Link]] | ||
| + | | style="text-align:center;" | [[The_--_field_notation_for_bxp_Forms|Link]] | ||
| + | | style="text-align:center;" | [[Special_--_notation_fields|Link]] | ||
| + | |- | ||
| + | |} | ||
| + | |||
| + | |||
| + | == 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. | ||
| + | |||
| + | |||
| + | = Replacements = | ||
| + | |||
| + | |||
| + | == Standard fields == | ||
* --period-- | * --period-- | ||
* --firstname-- | * --firstname-- | ||
* --surname-- | * --surname-- | ||
| + | |||
| + | |||
| + | == 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 | ||
| + | |||
| + | |||
[[Category:Topic:Key Concept]] | [[Category:Topic:Key Concept]] | ||
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
