Date in Salesforce acceptable format

[darshthakkar]

Hi Team,

I have 2 fields, Start and End Date coming from upstream systems (i.e. snowflake) in UTC and want this to be inserted to downstream systems (i.e. Salesforce) in UTC as well. After developing the pipeline, we found that the dates are off by 4 hours when it goes into Salesforce.

Thus, I tried changing the date to EST format in order to resolve the issue however at Salesforce, the dates are further going off by 4 hours.

Should I just add 4 hours in my mapper which formats date so that it goes as is in Salesforce? If that’s the case, how should I add those 4 hours? It seems like the Salesforce Org is GTM-4 therefore it always converts the time - 4hours.

Some screenshots for convenience.

1. Snowflake execute with the below settings:
   

2. EST Add-on:
   

With the EST add on, the dates on Salesforce is going as 2025-12-29T15:00:00Z which is 29 Dec 2025 3pm.

3. Removed EST Add-on:
   

While removing the EST add-on, dates on Salesforce is still going as (Date - 4 hours) i.e. 29 Dec 2025 8pm.

How can I tackle this?

Thanking in advance for your time.

Regards,
Darsh

[darshthakkar]

I was putting the function at the wrong place but I was able to add the hours if I used the below string:

$Expire_Date.plusHours(4).toLocaleDateTimeString({format: "yyyy-MM-dd'T'HH:mm:ss'Z'"})

[darshthakkar]

I’m not sure whether adding 4 hours to the transformation is a good practice as I’m a huge proponent of using time zones for ease.

I’ll keep everyone posted on this thread if I find something interesting, until then closing this thread.

[darshthakkar]

darshthakkar:

I was putting the function at the wrong place but I was able to add the hours if I used the below string:

$Expire_Date.plusHours(4).toLocaleDateTimeString({format: "yyyy-MM-dd'T'HH:mm:ss'Z'"})

This works however what throws me away is the fact that it doesn’t work for a few, I’m anticipating errors on Salesforce side but is there a way I can better code this so the results remain consistent on the downstream systems as well?

Data in Snowflake:

Data in snapLogic going into Salesforce: (added 4 hours thus the difference in time)

Data ingested in Salesforce:

Expectation: Data in snowflake <==> Data ingested in Salesforce

CC: @koryknick @ptaylor @bojanvelevski

Regards,
Darsh

[darshthakkar]

Transformation rule for converting the date into the following format: 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.