H hoachen Oct 30, 2009 #1 I would like to change the date format from 10903011 (mean 03/11/2009) to 03/11/2009? the datatype is number. Thanks
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 Oct 30, 2009 #2 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.
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.
