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 18: | Line 18: | ||
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 = | ||
* --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]] | ||
Revision as of 22:49, 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 Standard fields
- --period--
- --firstname--
- --surname--
3 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
