There's more to experience when you log in!
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.
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.