Suffixing date with date format abbreviation (e.g. EST, UTC, IST, etc.)

[darshthakkar]

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

[darshthakkar]

$Expire_Date.toLocaleDateTimeString({format: "yyyy-MM-dd'T'hh:mm:ss'EST'"})

[Supratim · Accepted solution]

darshthakkar:

yyy-MM-dd’T

@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.

[darshthakkar]

Thank you @Supratim, I was able to test this out and it worked!

[VaishnaviB]

Hi @Supratim ,

Can you please help me on this.

I have tried as mentioned

 Date.now().toLocaleDateTimeString({“format”:“YYYY-MM-dd'T'HH:mm:ss z”,“timeZone”:“IST”}) 

which is giving me in UTC as below

_snaptype_datetime:"2024-03-12T09:15:05.038 UTC"