Convert number to a date

[Guest]

I have a textbox that is being autofilled. The number being entered is for
example 12282005. How do I convert this to the date 12/28/2005?
Thank you for your assistance

 

[Van T. Dinh]

DateSerial( Right([DateText], 4), Left([DateText], 2), Mid([DateText], 3,
2) )