โ08-15-2022 11:28 AM
Continuing the discussion from Date in Salesforce acceptable format:
Hi Team,
I actually need the following format for date: 2023-02-28T00:00:00.000 EST
Iโm currently using $Expire_Date.toLocaleDateTimeString({โformatโ:โyyyy-MM-ddโTโHH:mm:ss.SSSโ,โtimeZoneโ:โAmerica/New_Yorkโ})+" EST" which is working on the output preview but unable to ingest records in the downstream systems i.e. Salesforce. Iโm suspecting that the date format is causing an issue as previously without the modification of the Expire Date, the pipeline was able to ingest data downstream. Moreover, the same format of the data is able to go into Salesforce if we do it manually.
Do you agree that the transformation Iโm using is correct? Is appending โESTโ as a string causing an issue? How can I have EST embedded automatically without writing "+ โESTโ "?
Also, if I need to have timezone of Mauritius for instance or Singapore, what would the function look like?
Thanking you in advance for your time.
Regards,
Darsh
Solved! Go to Solution.
โ08-15-2022 11:38 PM
@darshthakkar Can try this option- .toLocaleDateTimeString({โformatโ:โYYYY-MM-ddโTโHH:mm:ss zโ,โtimeZoneโ:โISTโ}) will give you โ2022-08-16T12:06:55 ISTโ format.
โ03-12-2024 09:41 AM
Try the below expression:
Date.now().toLocaleDateTimeString({"timeZone":"Asia/Kolkata", "format":"yyyy-MM-dd HH:mm"})
Reference:
For the {"timeZone":"zoneValue"} option, you can use the Canonical ID value from Joda-Time.