Data360 Analyze

 View Only

  • 1.  convert a date which has no zero on the month

    Employee
    Posted 09-10-2021 06:34

    Hi

    I have date being passed which has no leading zero (although a zero is present when appropriate).

    e.g. 7/15/2021 so in a format m/dd/yyyy

    How do i convert this into a format of yyyyMMdd ? So it adds the zero where appropriate.

    Thanks

    Martin



  • 2.  RE: convert a date which has no zero on the month

    Employee
    Posted 09-14-2021 02:08

    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'