Latest revision as of 22:50, 13 March 2018

Overview

If building a custom group it can be useful for Worklists and CrossLinked lists to have dynamic dates in the queries. This article shows how to add dynamic dates to your data group limiting.

In the custom data fields page you are adding in a keyword.

Please note that your data must be in universal date time format for the filters to work.

For all the combinations please review Standard_field_replacements#Date_Time_fields

For all the possible letter combinations please review http://www.w3schools.com/asp/func_dateadd.asp

@@ Line 13: / Line 13: @@
+For all the combinations please review [[Standard_field_replacements#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

Personal tools

Search

Namespaces

Views

Export pages

Actions

Difference between revisions of "Custom Group dynamic dates"

From All n One's bxp software Wixi

Latest revision as of 22:50, 13 March 2018

Overview

Navigation menu

Navigation

Tools