Custom Group dynamic dates

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.

--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