Substringing a date

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!

Parse

Date Time

Preparation

Accepted answers

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

You can use the DateTimeParse function to convert this date:

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

Thanks - great solution!

Thanks - good to know this