convert from decimal datatype to date

[coachvi]

convert this
yy/mm/dd
20,111,015.00 to date 2011/10/15

 

[IanWaterman]

Try

Date(tonumber(left(totext({Field}),4)),
tonumber(mid(totext({Field}),5,2)),
tonumber(mid(totext({Field}),7,2))

Ian

 

[lbass]

Tweaked:

Date(tonumber(left(totext({Field},0,""),4)),
tonumber(mid(totext({Field},0,""),5,2)),
tonumber(mid(totext({Field},0,""),7,2)))

-LB

 

[IanWaterman]

Good catch LB, forgot about the thousand delimiters.

Shouldn't you be celebrating Thanks Giving and not be on here!!

Ian