Philip Lacey at 21:50, 13 March 2018

2018-03-13T21:50:58Z

Philip Lacey: Created page with "= 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 dat..."

2015-11-10T17:17:38Z

Created page with "= 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 dat..."

New page

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

[[File:Dataprofiling customised 008.png|800px]]

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

[[Category:Module Specific:Data Profiling]]

← Older revision		Revision as of 21:50, 13 March 2018
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~~
−

Custom Group dynamic dates - Revision history

Philip Lacey at 21:50, 13 March 2018

Philip Lacey: Created page with "= 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 dat..."