Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

String to Date

tiverson
8 - Asteroid

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

tiverson_0-1646144545992.png

 

tiverson_1-1646144560451.png

tiverson_2-1646144584109.png

tiverson_3-1646144603270.png

 

11 REPLIES 11
trettelap
8 - Asteroid

@MarqueeCrew any reason in particular that you avoid datetime tool?

MarqueeCrew
20 - Arcturus
20 - Arcturus

@trettelap ,

 

Excellent question!  The datetime tool doesn't use ALTERYX standard specifiers (e.g. MM is month in the tool, but if you use specifiers it should be mm).  Specifiers are how you can handle any date formats:

 

https://help.alteryx.com/designer-cloud/datetime-functions#:~:text=date%20and%20time.-,DateTimeParse....

 

The performance of the tool is slower than a formula with the proper expression.  Once you learn WHERE to find the glossary quickly, then you can memorize through use of the specifiers.    You can go beyond simple data cleansing and answer higher-level questions about dates once you know how to handle them.  I want to find the first Monday of each month.  I want to find the last day of the month.  There are lots of questions that you will handicap yourself in answering if you aren't comfortable using date functions.

 

Cheers,


Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels