Convert String to Date

[rajukesarapu]

I am having a challenge in converting a sting to a date. This is one of the exercise files available within the learning path but the output returns null value. See attached configuration

[caltang · Accepted solution]

You can read here:

1. https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Convert-String-to-Date/td-p/33...
2. https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Need-help-converting-string-to...
3. https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Covert-String-Number-date-mmdd...
4. https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/convert-string-to-date-format/... 

[caltang · Accepted solution]

There is also a cheat sheet here: https://community.alteryx.com/t5/Engine-Works/DateTime-Functions-Cheat-Sheet/ba-p/844353 and you can read the functions more in depth here: https://help.alteryx.com/current/en/designer/functions/datetime-functions.html 

[rajukesarapu]

Thanks. Tried these and still cannot figure out a way. Can someone help sending me a formula or configuration to handle below conversion

10 January, 2019 -> 2019-01-10

[Qiu · Accepted solution]

@rajukesarapu 
If you go through the links that @caltang had shared, I do believe you should be able to do it.
Just for you to get started.