date format

[Sheena_Mae]

Hi! I'm new to alteryx and I need to convert these dates to "yyyy-MM-dd" from the format of the screenshot below.

I have tried toDate([Entry Date]) and DateTimeFormat ([Entry Date], "%y-%m-%d") but it did not work out.

Hope you could help me.

Thank you in advance.

[binuacs · Accepted solution]

@Sheena_Mae One way of doing this with the DteTimeParse function

[ShankerV]

Hi @Sheena_Mae 

We have 2 ways to achieve the solution.

Solution 1:

Please find the expected solution,

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @Sheena_Mae 

Step 1: Input

Step 2: Regex

Step 3: Date time tool

Output:

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[ShankerV · Accepted solution]

@Sheena_Mae 

Solution 2:

Via formula tool, datetimeparse function

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[Sheena_Mae]

Thank you very much! The solutions worked :D

[Sheena_Mae]

Thank you very much @binuacs! very helpful :D