date format

Question

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.

binu_acs · Accepted Answer

@Sheena_Mae One way of doing this with the DteTimeParse function

ShankerV · Accepted Answer

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 Answer

@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