topic Re: RTDM - Datetime variable for Data Process (insert type) in SAS Customer Intelligence

RTDM - Datetime variable for Data Process (insert type)

teresa_abbate — Mon, 05 Sep 2016 10:21:51 GMT

Hi all,

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?

Thank you!

Teresa

Re: RTDM - Datetime variable for Data Process (insert type)

shill — Tue, 20 Sep 2016 13:31:16 GMT

This feels like a timezone issue, perhaps. What timezone is your RTDM server using? What timezone is the database using?

Re: RTDM - Datetime variable for Data Process (insert type)

teresa_abbate — Mon, 26 Sep 2016 09:16:45 GMT

Hi Shill,

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.

Re: RTDM - Datetime variable for Data Process (insert type)

shill — Tue, 04 Oct 2016 21:41:43 GMT

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.