EBIFour.com Training Clarify Tips Populating a DateTime Field yyyy-MM-dd’T’HH:mm:ss.SSSZ
Populating a DateTime Field yyyy-MM-dd’T’HH:mm:ss.SSSZ
13th March 2020
In our 2 previous Cleo Clarify Date Conversion posts (below), we discussed how to populate a datetime target field with the proper format – yyyyMMddTHHmmss
In our Cleo Clarify post (below) we show another approach to convert a date / time into the format: yyyy-MM-dd’T’HH:mm:ss.SSSZ
CreateDateTimeFromString
In our ruleset we we will use the rule:
CreateDateTimeFromString
and pass in a date of yyyy-MM-dd
In
CreateDateTimeFromString, the FormatPattern will be yyyy-MM-dd’T’HH:mm:ss.SSSZ
By: Sean Hoppe on