Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
mani1304
Creator
Creator

Date issue in Salesforce Date

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:MISmiley FrustratedS.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.

 

Labels (3)
1 Solution

Accepted Solutions
mani1304
Creator
Creator
Author

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

View solution in original post

2 Replies
manodwhb
Champion II
Champion II

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

 

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

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