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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.