Convert String to Date

Hello all,

How do I convert 09222018 to a date? I can't get the string to date function to work because I think I have to have it in yyyy-mm-dd format. I tried different ways and cannot achieve this. I also tried the datetimeparse formula, but keep getting a null value.

DateTimeParse([Timestamp UI],'%mm-%dd-%yyyy')

Thanks in advance.

Jesse

Date Time

Accepted answers

The format you provided was incorrect: see Specifiers https://help.alteryx.com/current/Reference/Functions.htm?Highlight=date

I attached a workflow as an example.

All comments

The format you provided was incorrect: see Specifiers https://help.alteryx.com/current/Reference/Functions.htm?Highlight=date

I attached a workflow as an example.

This community is awesome!!!!!! Thank you so much!!

Tenho uma data, 20210101 como converto isso para uma data 01/01/2021?

First weekly challenge completed!

Week 2 Challenge.yxmd

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15878

MarqueeCrew 13708

apathetichell 13703