Salesforce Timestamps

[pfmd86]

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

2018-12-18T12:00:00.000+0000

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

This is the output I get:

2018-12-18T12:00Z

Instead of the +0000 I get a “Z”

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

[ipazin]

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

Br,
Ivan