Text to time conversion

[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?

 

[John W. Vinson]

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?

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

 

[glen]

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

Thanks John, that worked just fine.

 

[glen]

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

Thanks John, that worked just fine.