Date and Time format

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

Guest

I have a database in which I store some date and times. When from Excel I
use the MSQuery Tool to return the information it is bringing the date and
time back as
9/3/2005 0:00 1/0/1900 11:00 1/0/1900 12:00 When what I want is:
9/3/2005 11:00 12:00 I am not very good with this stuff, so is there a
simple way to get rid of this extra info?


Thanks for any help
 
Back
Top