Converted Date is not valid

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?

Transformation

Accepted answers

All comments

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')

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703