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