String field convert to date

I have a string field, 12.30.14 that I need to format into a date field mm/dd/yy.
Using the formula below, it returns 3/30/12,

Can you identify what I am doing wrong?
Thanks!

if isnull({@Split Left Email Name}) then Date(0,0,0)

else

if ({@Split Left Email Name}='') THEN Date(0,0,0)

ELSE

Date(ToNumber(LEFT({@Split Left Email Name}, 2)),
      ToNumber(Mid ({@Split Left Email Name}, 4, 1)),
     ToNumber(Mid ({@Split Left Email Name}, 4, 2)))
rporter45Asked:
Who is Participating?
 
mlmccCommented:
I assume that date is supposed to be 30 Dec 2014

Try changing date statement to

Date(ToNumber(Right({@Split Left Email Name}, 2)),
       ToNumber(Left({@Split Left Email Name}, 2)),
      ToNumber(Mid ({@Split Left Email Name}, 4, 2)))

If that doesn't work what is the @split formula?

mlmcc
0
 
rporter45Author Commented:
Works perfectly!! Thank you,

Colleen Slater
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.