Convert Text to Date

[britknip]

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?

[MarqueeCrew · Accepted solution]

@britknip,

As text, you could use:

left([DateID],4) + "-" + Substring([DateID],4,2)

That's one way to get it done.

Cheers,

Mark

[britknip]

That worked perfect. Thank you!

[LordNeilLord · Accepted solution]

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

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[britknip]

The previous user helped me but this link is awesome. Very helpful. Thank you!