Date: Feb 2008
Product & Version: NVBU any
OS Version: any
Module & Version: NA
Symptoms: When using custom reports based on date/time, a larger window of data is reported than expected.
In the fields available for reporting, we have both "startdate", "starttime" and "startdatetime".
"startdate" is date only, and rounds to midnight of the start of the day in question
"starttime" reports hours and minutes only
"startdatetime" reports the date and time.
When using relative time filters in hours (e.g. NOW -16HO), this must be compared to a reporting element with a time component, ie."startdatetime". If "startdate" is used, then more data than required will be reported as the date rounds the time element back to midnight of that day.
Note that the "Historic Jobs - By Date" report uses "startdate" as its default filter, so if using this as a basis for a time based report, remove the existing filters and substitute "startdatetime" based ones.