Showing a date field as a number

[AJCB]

Hi.
I was wondering if there was any way that I could have a column showing the
date and time (20/12/2007 06:00:00) and another column show the date and time
as a number, (29548). This would be done in a select query, but I am not
sure how?
Is it possible?

Regards
AJ

 

[Al Campagna]

AJ,
Use format...
mm/dd/yy hh:nn:ss
for 20/12/2007 06:00:00
Use format...
#.0000 (with Decimal Places = to suit your needs)
for 39436.2500
Use format...
# (with Decimal Places = 0)
for 39436
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Arvin Meyer [MVP]]

Sure, a date is really just a specially formatted Double, so just add a
column to your query to convert it back:

Expr1: CDbl([Your Date Field])

 

[AJCB]

Ok. I will give this a try in the morning.
Thanks for your help guys!!!

AJ