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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Every New Tasks Wants to Start in the Future 1
Percentage change 9
Publisher 2019 Format Picture window size too large to display OK button 0
Dates In Excel 5
Display month as 01, 02 ect not 1, 2 , 3 2
Last day of month in query 15
Merge records with same number 0
Help with special query, confused 7

Top