Salesforce Timestamps

I’m getting timestamps as strings from a report from salesforce in this format:


So, I used the “String to Date” node to get a DateTime with timezone.

This is the output I get:


Instead of the +0000 I get a “Z”

Any idea of how to get the right date format with timezone?

Hi @pfmd86,

this is just truncated view as seconds, milliseconds and offset are zero in your example. For seconds and milliseconds it is expected and if you check node description you’ll see that next to X placeholder there is note “‘Z’ for zero” so it is expected as well.
If you have following string you can see all parts: 2018-12-18T12:01:01.001+0700


This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.