Problem Note 41586: Unable to type formatted date values into the filter dialog
 |  |  |  |  |
If you attempt to filter data in the SAS® Add-in for Microsoft Office within the Filter and Sort window, the results may not return the expected values. The filter will ignore your date value and return the data without that filtered value. In previous releases of the SAS® Add-in, typing in the formatted value performed properly.
To circumvent this issue, type in the date value in a date literal format, like so:
"01apr2010"d
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 Add-in for Microsoft Office | Microsoft® Windows® for x64 | 4.2 | 5.1 | 9.2 TS2M0 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 5.1 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 5.1 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 5.1 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 for x64 | 4.2 | 5.1 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2008 for x64 | 4.2 | 5.1 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows XP Professional | 4.2 | 5.1 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Windows Vista | 4.2 | 5.1 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Windows Vista for x64 | 4.2 | 5.1 | 9.2 TS2M0 | 9.2 TS2M0 | ||
A fix for this issue for SAS Add-in for Microsoft Office 4.22 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/A54.html#41586A fix for this issue for SAS Add-in for Microsoft Office 4.305 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/C46.html#41586A fix for this issue for SAS Add-in for Microsoft Office 4.3 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/D19.html#41586| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2010-11-12 16:24:17 |
| Date Created: | 2010-11-12 15:47:15 |