Usage Note 12721: Using the IN operator with DATEs in HCM may produce unwanted results
In SAS Human Capital Management 3.1 (HCM, HRV, HR Vision) you may
experience several issues with dates within the query tool.
If the WHERE clause contains the "IN" operator, and several
comma-separated dates have been specified, only the first date is kept
after the "Filter" page has been exited and returned to.
You may receive the message that "An illegal character was found".
If you select the dates you would like to include in the "IN" operator
from a list of actual values, and these values are already in US format,
then the reading of these dates, using the local date format, might
fail.
A Technical Support hot fix for this issue is available at:
http://www.sas.com/techsup/download/hotfix/hr_vision31.html#012721
Operating System and Release Information
| SAS System | SAS Human Capital Management | Microsoft Windows 2000 Professional | 3.1 | | | |
| Microsoft Windows NT Workstation | 3.1 | | | |
| HP-UX | 3.1 | | | |
| 64-bit Enabled Solaris | 3.1 | | | |
| Solaris | 3.1 | | | |
| 64-bit Enabled HP-UX | 3.1 | | | |
| AIX | 3.1 | | | |
| 64-bit Enabled AIX | 3.1 | | | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Usage Note |
| Priority: | medium |
| Date Modified: | 2004-07-14 16:48:46 |
| Date Created: | 2004-06-28 09:46:40 |
