Date

[hi2019]

Hi,

I need it in format MM/DD/YY , its coming in as V String 20201230  and I tried Date-Time tool from string to Date Custom %m %d %Y but its null

I tried Date formula      Date Time Format([CHECK-ISSUE-DATE],"%m/%d/%Y") 

didn't work either

[DataNath]

Hey @hi2019 - you need to parse the string (20201230) into an ISO DateTime format (YYYY-MM-DD) using DateTimeParse(), as this is the only format Alteryx can work with. Once it's in this format, you can then convert it into a string with a custom format, using DateTimeFormat(). Assuming your input format is YYYYMMDD, this would look like so:

DateTimeFormat(DateTimeParse([CHECK-ISSUE-DATE],'%Y%m%d'),'%m/%d/%y')

Note: You'll need the new field's data type to be a string as Alteryx can only store/work with dates in the format above, which this isn't.