The operator "Before (>)" or "Since (<=)" with the range "Date" is unavailable in the report query "Date Created".

Article:TECH56851  |  Created: 2008-01-17  |  Updated: 2013-09-27  |  Article URL http://www.symantec.com/docs/TECH56851
Article Type
Technical Solution


Environment

Issue



The operator "Before (>)" or "Since (<=)" with the range "Date" is unavailable in the report query "Date Created".


Solution



The operator "Before (>)" or "Since (<=)" with the range "Date" is unavailable in the report query "Date Created". If running the reports using the operator "All dates" or "Between" with the range "Date" in the report query "Date Created", the unexpected results may output. Therefore, replace with the other ranges, with the different operator or with the customized queries in one of the three workarounds below.

Workaround 1 - Replacement with the other ranges:
Specify the range "Days", "Months" or "Years" instead of "Date". (Figure 1)

Figure 1
 

Workaround 2 - Replacement with the different operator:
Specify the operator "All dates" or "Between" with the range "Date" instead of "Before (>)"  or "Since (<=)". (Figure 2)
For instance, input as follows when needing to query the created date before July 25 2007,
[Between]  [Date] [1/1/1900] and [7/25/2007]

Figure 2
 

Workaround 3 - Replacement with the customized queries if using the Advanced Reporting Option:
Create a new report query and specify the date and operator in the report query as below. (Figure 3)
For instance, input as follows when needing to query the created date before July 25 2007,
Created < {07/25/2007 00:00:00}

Figure3
 

 

Supplemental Materials

Value1142178
Description

The query "Date Created" is not correctly reported.


Legacy ID



296181


Article URL http://www.symantec.com/docs/TECH56851


Terms of use for this information are found in Legal Notices