String to Date

[tiverson]

I have data that looks like a date, but is a string.

When I try to convert it to a date, I receive a null.

I have tried 3 or 4 different text to string actions but none return a value.

What am I doing wrong?

Thanks

[atcodedog05 · Accepted solution]

Hi @tiverson 

The format you need to use is

Hope this helps : )

[binuacs]

@tiverson 

[RolandSchubert]

Hi @tiverson ,

you can use a Formula tool and the function DateTimeParse. Create a new column and set the type to "Date".

Formula should be: DateTimeParse([Name], '%Y_%m_%d')

Let me know if it works for you.

Best,

Roland

[MatthewBr]

[MatthewBr]

try that version worked for me.

[MarqueeCrew]

@tiverson ,

You've got lots of responses for your post with help from @MatthewBr , @RolandSchubert ,  @binuacs  and @atcodedog05 .  I personally avoid the DATE TIME TOOL.  I like the DateTimeParse() function solve, but to keep it simple, here is the easiest way:

ReplaceChar([Name],"_",'-')

Cheers,

Mark

[atcodedog05]

Hi @tiverson 

I agree with @MarqueeCrew replace would be the best option that was my first thought too. But I wanted to show you what you might be doing wrong and how you can fix it 🙂

Happy to help : )

[atcodedog05 · Accepted solution]

Happy to help : ) @tiverson 

Cheers and have a nice day!

[tiverson]

Thank you so much to everyone for all your help!