Home > IT Answers > Database > Convert time as text to datetime
Help

Question

  Asked: May 15 2008   11:53 AM GMT
  Asked by: VentureFree

Convert time as text to datetime


Microsoft Access, DateTime

I've got a stupid table that I have to work with (and no, I can't change it) that stores times of certain events as text (example: '10:25 pm' or '3:02 am'). This table has an actual date to work with, which is essentially just the date with no time component. Know what I'm going to ask yet? You guessed it...how can I add the time to the date to get a single datetime against which I can compare other datetimes? I want to do that as part of a query

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: May 15 2008  11:55 AM GMT  by VentureFree




ARGH! I got stupider by working with this guys stuff. the date + CDate(time) works. Sorry for wasting your time.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Database and Development.

Looking for relevant Database Whitepapers? Visit the SearchOracle.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register