09-05-2016 06:21 AM
i created a custom Data Process node for updating the ResponseHistory table.
I need set RESPONSE_DT, RESPONSE_DTTM, PROCESSED_DTTM with the sysdate's value.
The version of RTDM is the 6.4 and in this version the DateAndTime.today (native SAS date variable) is available. Using this variable, the 3 date field are updated two hours back.
I'd create a new date variable so that: NewDateVariable= DateAndTime.today + 2h.
I've tired with INTNX funcion: NewDateVariable=INTNX('hour',< DateAndTime.today>,2) but the outup is incorrect, i lost the information about mintes and seconds. The 'same' option is not accepted.
Wich function can I use to solve?
09-26-2016 05:16 AM
Both timezone are set on Europe/Rome. This problem occours only with custom Data Process (insert mode).
No probelm with the RTDM standard nodes ("Update Response" node or "Confirm Contact" node), they insert record with the right date value.
10-04-2016 05:41 PM
I'm beginning to think this warrants a technical support track, but you could also look at the info in this SAS Note: http://support.sas.com/kb/55/831.html
It's specifically about retrieving data, but that doesn't mean it wouldn't help with inserts. It's worth checking to see if the hotfix is relevant to your environment, anyway, and installing it if it isn't already.