Working with Dates in Alteryx

Alteryx is an extremely powerful tool when attempting any date related calculations - it knows what months had 30 or 31 days and even knows which years were leap years. However, to access this functionality, the input data must be formatted in the specific Alteryx Date format. Join Data Prep U as we demonstrate how to parse your data to format date inputs correctly within Alteryx allowing for these incredibly useful date calculations to be performed.

[@tameikamartin7141]

Thank you! I’ve been looking for an easy to follow demonstration, it took a while before I found this demo that actually helped me!

[@tiagomartins553]

This is absolutly amazing

[@district144]

thank you so much for your help!!!

[@ranodurjoysarkar5000]

Nice explanation, Finally It's all clear to me.
To convert string to date - we use datetimeparse
To convert date to string- we use datetimeformat

[@ronrui5108]

Good info! however, even i added the parse time tool the date didn't appear at all!

[@eduardoxaviergomes3328]

Great, Would you think it would be possible create a date list with data starting with current month and apply a week days names? Thanks.