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!
Solved! Go to Solution.
You can also use datetime tool to convert your string into date.
Thanks - great solution!
Thanks - good to know this