Change Date format

H

hoachen

I would like to change the date format from 10903011 (mean 03/11/2009) to
03/11/2009? the datatype is number.

Thanks
 
J

Jerry Whittle

CDate(Mid(10903011,4,2) & "/" & Right(10903011,2) & "/" & Mid(10903011,2,2))

Replace 10903011 with the field name in [ ] . If there are any null fields
or invalid dates, like 2/30/2009, then you will get an error.
 
Top