Problem Note 60449: Incorrect datetime values are exported when you use tags to reference the Date-Time Range custom field in a treatment
When you use tags to reference a Date-Time Range custom field in a treatment, SAS® Customer Intelligence exports all datetime values as Jan 1, 1960.
This problem occurs when you perform steps similar to the following:
- Create a treatment with Date-Time Range custom fields and associate those fields with tags so that they can be used in an Export node.
- Create an export definition that references the tags that write the output to a SAS data set.
- Create a campaign using this treatment-and-export combination.
- Enter dates and times into the treatment Date-Time Range fields.
- Save and execute the campaign.
After you save and execute the campaign, the datetime values are written to the SAS data set as Jan 1, 1960, which is incorrect. This problem does not occur if the range fields are defined as date values rather than datetime values.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Customer Intelligence Processes | Microsoft® Windows® for x64 | 6.5 | | | |
64-bit Enabled AIX | 6.5 | | | |
64-bit Enabled Solaris | 6.5 | | | |
HP-UX IPF | 6.5 | | | |
Linux for x64 | 6.5 | | | |
Solaris for x64 | 6.5 | | | |
*
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: | Problem Note |
Priority: | high |
Date Modified: | 2017-07-19 11:22:56 |
Date Created: | 2017-05-10 11:38:57 |