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

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....
 
S

Steve Schapel

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))
 

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
Convert date to serial number format 1
Date Serial Problem 2
Changing date in number format to dd/mm/yyyy? 5
Excel Extracting from serial date format in Excel 1
Convert date to serial number 12
Date serial No.s to date format 2
How to display database in a calendar format 22

Top