I am having an issue converting my text to a date. This is the current format 20180124. I would like to pull out year and month. Any suggestions? I have tried using a select tool and converting the DateID from V-String to String and then using formula DateTimeFormat([DateID],"%Y-%m")
Everything comes back Null.
Any suggestions?
Solved! Go to Solution.
That worked perfect. Thank you!
Hey @britknip
What is the final format that you are looking for your date to be in?
To turn your string into a "real" date use: DateTimeParse(ToSTring([Field1]),"%Y%m%d")
The next step will be dependant on your final requirement. I always use this page when trying to figure out the datetime functions: https://help.alteryx.com/9.5/Reference/DateTimeFunctions.htm
Part time Tableau, Part Time Alteryx. Full Time Awesome
The previous user helped me but this link is awesome. Very helpful. Thank you!