converting Excel integer date format

R

RB Smissaert

I am opening a text file (see thread: automate open text file) that has a
column with the Excel integer date format, the ones like this: 38855.
What is the easiest way to convert this in Access to a date like this:
dd/mm/yyyy?
Thanks for any advice.

RBS
 
B

bart.smissaert

Figured this out now. Go into design view, selec the field and put
dd/mm/yyyy in the format edit box.

RBS
 
B

bart.smissaert

Figured this out now. Go into design view, selec the field and put
dd/mm/yyyy in the format edit box.

RBS
 

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

Text to date format? 0
printing report with date 3
Converting date from an external source 1
Converting an Integer into a Date 3
Date Format Question Again 2
Excel date format YYYYMMDD 1
Date Formatting 1
International Date Values - Access 2007 3

Top