Converted Date is not valid

[saachitalwar]

The data has dates in the form 2024-05-17 and I wish to convert it to 170524 as this is the template filename for the output.

I used DateTime tool to convert the input date into a string then used this formula - DateTimeFormat([Output Path],"%d%m%y")

this is giving me conversion error - 

Formula (14) Output Path: 170524 is not a valid Date

This is the exact output I want but it's coming out as null. How can I get this format of date?

[saachitalwar]

sorry, I used DateTime tool to convert the input string* into a date*

[binu_acs]

@saachitalwar @Make sure the data type is String not Date data type, Alteryx only support ISO date types which is in the format YYYY-MM-DD

[Raj]

@saachitalwar is this solved?

[saachitalwar]

no, not yet

[binu_acs]

@saachitalwar Can you screen shot your formula? Are you using formula tool? If not use the formula tool with the above formula you mentioned and change the data type to string. Also make sure your in put data is Date Type

[cjaneczko]

Try the following.

datetimeformat(DateTimeParse([Output Path],'%Y-%m-%d'),'%d%m%y')