Data Transformer Format Time Issue

Google Cloud Integration Services
, ,
1

Hi, I am using data transformer task and using format date operation to convert an incoming date time into an appropriate format.

The incoming date is in the following format “2026-02-10T18:22:32.323Z” and i want to convert it into yyyy-MM-dd HH:mm:ss however I try the operation is facing. I have used the following formats to match the incoming date&time yyyy-MM-dd’T’HH:mm:ss.SSSX and yyyy-MM-dd’T’HH:mm:ss.SSSZ but neither of them work. I get the below error, can someone guide me what is the mistake I am doing ?

RUNTIME ERROR: Value 2026-02-11T01:20:18.758Z does not match format yyyy-MM-ddTHH:mm:ss.SSSZ functions:48:74-142 function template:3:152-261 object Field “CreatedDate” Field “SalesforceJSONData” During manifestation : invalid argument: invalid argument

1 Like
2

Try using “YYYY-MM-DDTHH:mm:ss.fffZ“ as your input format and “YYYY-MM-DD HH:mm:ss“ as output format

1 Like
3

sure let me give a try and see

4

The issue is with the input format not matching the incoming timestamp. Use this in your Data Transformer task:

Input format: yyyy-MM-dd’T’HH:mm:ss.SSS’Z’
Output format: yyyy-MM-dd HH:mm:ss

Make sure to include the literal ‘T’ and ‘Z’ in single quotes so the parser treats them correctly. This should resolve the runtime error.

1 Like