Substringing a date

[Izbiz]

Hello!

I have a date column where the dates are given like "20110601" (year, month day)

I am going to seperate out the date parts and convert this to a date time . 

However I get an issue when using a formula tool as follows:

LEFT([0CALDAY],4) + '-' + substring([0CALDAY], 5,2) +'-' + RIGHT([0CALDAY],2) 

returns "2011-60-01" - so the substring function is getting rid of the lead zero. Anyone know any work arounds for this?

Thanks!

[LordNeilLord]

Hey @Izbiz

You can use the DateTimeParse function to convert this date:

[ponraj · Accepted solution]

You can also use datetime tool to convert your string into date. 

[Izbiz]

Thanks - great solution!

[Izbiz]

Thanks - good to know this