For example, specifying the criteria =(#:D '2000-03-10') would return records from any time in the same day, for example, 12:00:00 A.M., 2:00:00 P.M., 5:00:17 P.M., or any other time. In other words, when you define date criteria and do not specify a time, GE Digital APM assumes that the time is unimportant and does not take it into account when retrieving results.
In prompts, however, the time is always taken into account. It's suggested that you always create date prompts using the Distinct List of Values from <Field> option. This way, the list of available dates and times will always represent valid dates and times that exist in records in the database. You will not need to know what values are stored in the database or how to enter dates in the proper format in order to return the desired results.
Otherwise, if you create a prompt on a date field and do not define a list of valid values, you will need to know how to enter a date that will retrieve the desired results:
- If you enter a date with no time, the query will return records where the time is 12:00 A.M. Records that contain any other time will not be included in the results.
-
If you enter a date and a specific time, the query will return records that contain that specific date and time.
Note: You must specify the seconds value as 00. Entering any other value will cause the query to not return any results.
- If you use the Calendar to select a date, you will need to modify the time manually in order to include seconds, which are required to return results. Either enter a different time, or delete the existing time (to use a time of 12:00:00 A.M.).
All dates and times in GE Digital APM are stored in UTC format, and, the time values will be displayed using the appropriate conversion from UTC to the time zone that is associated with the Security User who is logged in when the query is run. This allows any user who runs the query to provide a local date and time in the prompt.