Hi all, i'm using RTDM 6.4, I need to create a new DATE variable to write the correct sysdate (Timezone: Europe/Rome) on a staging table. I must write it in a TIMESTAMP field mapping the related insert viariable of an insert data process. I tried to use the "Today's Date and Time" Out of the Box variable but i've seen that it writes always the UTC datetime. I also tried to use the following conversion functions in the calculated variable editor but the date written on DB is always in UTC: "GETDATEINTIMEZONE(<<DateAndTime.today>>,'Europe/Rome')" TODAY('Europe/Rome') Any suggestions about the calculation of a new variable, even in DS2 code, to write the correct italian sysdate also respect the change from solar to legal time. Thank you, Alessandro
... View more