Text to time conversion

  • Thread starter Thread starter glen
  • Start date Start date
G

glen

How do i convert a text string to a time format.
ie. 3:15pm or 8:13am to a time format that i can run querries with a
criteria of anything later than 3PM?
 
How do i convert a text string to a time format.
ie. 3:15pm or 8:13am to a time format that i can run querries with a
criteria of anything later than 3PM?
Click to expand...

CDate() will do it. Access Date/Time values are stored as numbers, a count of
days and fractions of days (times) since an arbitrary start point; so 3pm is
actually stored as 0.625 and is equivalent to #12/30/1899 15:00:00#.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 
CDate() will do it. Access Date/Time values are stored as numbers, a count of
days and fractions of days (times) since an arbitrary start point; so 3pmis
actually stored as 0.625 and is equivalent to #12/30/1899 15:00:00#.
--

             John W. Vinson [MVP]
 Microsoft's replacements for these newsgroups:
 http://social.msdn.microsoft.com/Forums/en-US/accessdev/
 http://social.answers.microsoft.com/Forums/en-US/addbuz/
 and see alsohttp://www.utteraccess.com
Click to expand...

Thanks John, that worked just fine.
 
CDate() will do it. Access Date/Time values are stored as numbers, a count of
days and fractions of days (times) since an arbitrary start point; so 3pmis
actually stored as 0.625 and is equivalent to #12/30/1899 15:00:00#.
--

             John W. Vinson [MVP]
 Microsoft's replacements for these newsgroups:
 http://social.msdn.microsoft.com/Forums/en-US/accessdev/
 http://social.answers.microsoft.com/Forums/en-US/addbuz/
 and see alsohttp://www.utteraccess.com
Click to expand...

Thanks John, that worked just fine.
 
Back
Top