How to format a time value into a 24 hr one. 1

[steve728]

I want to convert a field's string content of "6:00" to "18:00"). Do I use the use the format() function? Will someone show me how to do this??

Thanks in advance.

Steve728

 

[randy700]

Use an update query.

UPDATE myTable SET myField = "18:00" WHERE myField = "6:00"

Randy

 

[steve728]

Great. I should have been more generally explicit. How do I turn whatever time is in the field to it's 24 hour equivalent?

Thanks again,

Steve728

 

[missinglinq]

You question was clear enough; Randy's having an off day. The general syntax is

Format(YourTimeField,"hh:nn")

To do the opposite would be

Format(YourTimeField,"hh:nn am/pm")



The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[SkipVought]

CAVEAT: The Format function returns a STRING rather than a DATE/TIME value.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[aperez54]

Try

Cdate(Format(YourTimeField,"hh:nn")) to turn it from string to date format if you're using it as date criteria.