Problem Note 67130: DATETIME data items with the DTDATE9 format might generate problems in direct filters in SAS® Visual Analytics
 |  |  |  |  |
In SAS Visual Analytics, you might see the value 1Jan1960 when editing an existing filter.
For example, you encounter this issue when you perform steps similar to the following:
- Add an advanced filter to a list table or to any other report object that is based on a DATETIME data item.
- Add a date similar to the following to your advanced filter: DATETIME > 2 December 2010
The filter works fine.
- If you edit the advanced filter to modify it, the filter automatically changes from DATETIME > 2 December 2010 to DATETIME > 1 January 1960.
This problem mainly occurs when you apply the DTDATE9 format to the DATETIME data item.
To work around this issue, perform the following steps:
- Delete the direct filter.
- Change the DATETIME data item format from DTDATE9 to DTDATE11 or DATETIME0.
- Re-create the filter.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Analytics | Microsoft® Windows® for x64 | 7.5 | 9.4 TS1M6 | ||
| Linux for x64 | 7.5 | 9.4 TS1M6 | ||||
A fix for this issue for SAS Visual Analytics 7.51 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/I9T.html#67130A fix for this issue for SAS Visual Analytics 7.5 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/F9L.html#67130| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-11-16 08:06:32 |
| Date Created: | 2020-12-18 08:49:13 |