Skip to Content
0
Former Member
Aug 09, 2010 at 10:07 PM

Convert String to Date

592 Views

I know there are a lot of threads like this one out there, but this has gotten the best of me.

I have the following formula, but it's saying that the Month should be between 1 and 12

My date field is in the format of : yyyymmdd and I want it to show as dd/MM/yyyy

Date(tonumber(right({Command.CheckDate}, 2)), tonumber(mid({Command.CheckDate},5, 6)), tonumber(left({Command.CheckDate},4)))

Thanks