Anonymous, bureaucrat, administrator
7,528
edits
Changes
From All n One's bxp software Wixi
m
no edit summary
If you use the -- field replacement notation you can achieve dynamic opening scripts.
= Standard fields =
* --period--
* --firstname--
* --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]]
