Long Question sorry: Trying to use CDATE to convert some dates

  • Thread starter Thread starter seakin
  • Start date Start date
S

seakin

Hello all, First off I have no skills using access, but would greatly
appreciate any help.
I am trying to convert some times in a database using a query to a
normal date format they look like this in my Access table named
"users"

StartDate
37993.3314236111
37994.3501736111
37998.7087615741
37998.7412268519

EndDate
37993.331724537
37994.3504861111
37998.7090162037
37998.7414814815

I would like to somehow have them display a date like 1/10/2004 or
something similar. I am using a software called WebquizXP, an online
test taking software and it generates mdb files. I contacted their
support and got this response:

"They are in DOUBLE format. You can convert them to date with the CDATE
function in Access. Here's a sample MS Access query:

SELECT CDate(StartDate), * FROM User"


I have tried for a few hours now to get it working, but cannot seem to
get started in the right direction. If anyone can tell me the basic
steps to get started I would really appreciate it.
Thanks,
Sam
 
The values that you are seeing are actually how dates are stored internally.
For instance
cdate(37993.3314236111) = 1/7/2004 7:57:15 AM
You can just set the format of any text box displaying the value to General
Date.
Format(37993.3314236111,"general Date") = 1/7/2004 7:57:15 AM
 
"They are in DOUBLE format. You can convert them to date with the CDATE
function in Access. Here's a sample MS Access query:

SELECT CDate(StartDate), * FROM User"
Click to expand...

Someone was sleepy...

Use DateValue() instead of CDate().
 
John,
?????
I get an error when it try DateValue(225.1), but Cdate(255.1) returns 9/11/1900
2:24:00 AM .

This is in Access97, so maybe it differs in other versions.

John
 
John,
?????
I get an error when it try DateValue(225.1), but Cdate(255.1) returns 9/11/1900
2:24:00 AM .

This is in Access97, so maybe it differs in other versions.

John
Click to expand...

someone WAS sleepy... ME!

Sorry about that!
 
Back
Top