How do I convert a database "serial format date" to a calendar dat

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that stores dates in serial format (YYYYMMDD), I want to
use this field to have users select date ranges based on a normal calendar..
How do I convert this serial date so Access will let me group things by
month, or check the days that elapse between two serial date fields....
 
Kirt,

You can use this expression to convert your existing data to a valid date...
DateSerial(Left([YourField],4),Mid([YourField],5,2),Right([YourField],2))
 
You must log in or register to reply here.

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

Convert date serial from text to date value 4
Text to date format? 0
How to display database in a calendar format 22
hijri calendar 0
Date Serial Problem 2
Convert date to serial number format 1
Date serial No.s to date format 2
Convert date to serial number 12

Back
Top