Importing dbase tables w/dates

  • Thread starter Thread starter Mark Brown
  • Start date Start date
M

Mark Brown

I did the above and the dates are all wrong. DOB's of live people start at
1856.

Are there any functions or conversion methods to convert dBase dates to
Access 2007?
TIA
Mark
 
What do the dates look like in dBase?

Microsoft dates are special Doubles, with zero (0) being 12/30/1899. The
integer portion of the date is the day count and the decimal portion is the
time fraction of 24 hours (i.e. .25 is 6:00 AM).
 

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

DBase IV to Access 2k3 conversion. 1
Query by DOB 1
Conversion Advice 1
ACC2007: numeric fields truncated when imported from dBase III fil 1
Really simple date query won't work ... aaaarrrrgghh 6
ldb files 3
Dates with day below ten aren't found with docmd.applyfilter state 1
Two ?s: Automatic fields and Hiding Duplicates 2

Back
Top