We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

convert a date which has no zero on the month

Comments

1 comment

  • Avatar
    Adrian Williams

    The simplest method is to use the Modify Fields node. For example, if you have the following test data

    The Modify Fields node can be configured to auto-detect the data format as follows:

    Which would result in the following output data:

    To improve the reobustness of the detection mechanism you can also give the auto-detect mechanism a hint to allow it to resolve ambiguous date values by setting the 'AmbiguousDateResolutionMode' property to a value of 'Month First'

     

    0
    Comment actions Permalink

Please sign in to leave a comment.