Can-Ann

I have a string "20070714"

Can anyone show me how to convert this to

ddd-dd/MMM/yyyy

Thanks in advance.



Re: Crystal Reports for Visual Studio How to convert string to date

Joe Beam

Code Snippet

totext(cdate(tonumber(left({@string},4)), tonumber(mid({@string},3,2)), tonumber(right({@string}, 2))), "ddd-dd/MMM/yyyy")