Assure DQ

 View Only
  • 1.  Single digit month

    Employee
    Posted 03-23-2021 13:34

    Hello

    I have a file with date as 1/15/2021 and the format is m/dd/yyyy (the month appears as 2 digits wherever applicable. For Example 11/25/2021). I need to convert this into 011521 and the format is mmddyy. Please let me know how to go about it.



  • 2.  RE: Single digit month

    Employee
    Posted 04-01-2021 14:28

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    You need to first create a user-defined format that uses the format you want in the field for the control entity, then, when extracting, use fmtdate or date2 to translate the date you extract as mm/dd/yyyy to the one you want.