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

Cleo Clarify Ruleset with CreateDateTimeFromString format pattern


By: on