topic Re: Date issue in Salesforce Date in Talend Studio

Date issue in Salesforce Date

mani1304 — Sat, 16 Nov 2024 02:27:03 GMT

Hi All,

I need an urgent help on the below issues.

I need to put current date in the below format in Salesforce. Below Date is in Unix Format.

YYYY-MM-DDTHH24:MIS.nnn+ZO:NE

For this conversion, we are using the below format in Talend but this is changing the time zone, means 13 May 3 AM CST is changing to 12 May 10 PM CST.

RUN_DATE = TalendDate.formatDate("yyyy-MM-dd'T'HH:mm:ss'.000Z'",TalendDate.getCurrentDate())

Kindly suggest how to correct it.

Re: Date issue in Salesforce Date

manodwhb — Mon, 18 May 2020 05:45:25 GMT

@mani1304, you can use below way for example you need to get in UTC.

TalendDate.formatDateInUTC("yyyy-MM-dd HH:mm:ss", TalendDate.getCurrentDate() )

Re: Date issue in Salesforce Date

mani1304 — Mon, 18 May 2020 06:48:54 GMT

Thanks, I got that salesforce takes every date in UTC then converts accordingly.