Problem Note 64326: The SAS® Customer Intelligence LoadTreatments utility does not populate the "Activation date" and "Expiration date" fields properly as datetime values
 |  |  |  |  |
When you use the SAS Customer Intelligence LoadTreatments utility, the Activation date and Expiration date datetime values are not properly populated. This problem happens in the following situations:
- If you use a datetime value that is in the DATETIME22.3 format (for example, 01APR2019:00:00:00.000), the Activation date and Expiration date fields are not populated at all.
- If you use a datetime value in the DATE9. format (for example, 29apr2019), the Activation date and Expiration date fields are populated with a value of 12:00 AM by default, depending on the time zone.
However, you can manually set the proper time in SAS Customer Intelligence Studio, as shown below:
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 Customer Intelligence Utilities | Microsoft® Windows® for x64 | 6.5 | 6.6 | 9.4 TS1M6 | |
| 64-bit Enabled AIX | 6.5 | 6.6 | 9.4 TS1M6 | |||
| 64-bit Enabled Solaris | 6.5 | 6.6 | 9.4 TS1M6 | |||
| HP-UX IPF | 6.5 | 6.6 | 9.4 TS1M6 | |||
| Linux for x64 | 6.5 | 6.6 | 9.4 TS1M6 | |||
| Solaris for x64 | 6.5 | 6.6 | 9.4 TS1M6 | |||
A fix for this issue for SAS Marketing Automation 6.5 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Z77.html#64326| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-07-10 14:41:19 |
| Date Created: | 2019-06-13 04:33:11 |