Change PM to AM

[Guest]

I have a database where I need to change all current times from AM to PM. In
other words, if I have a field that currently reads 10:45 P.M. ~ I would like
to run a query that would change it to 10:45 A.M.

Any thoughts?

 

[Guest]

Add 12 hours with DateAdd("h",12,[YourField])

 

[John Spencer]

Don't forget to check and make sure that existing times are in the AM by
applying criteria to the field

WHERE Hour(YourField) < 12

Add 12 hours with DateAdd("h",12,[YourField])

I have a database where I need to change all current times from AM to PM.
In
other words, if I have a field that currently reads 10:45 P.M. ~ I would
like
to run a query that would change it to 10:45 A.M.

Any thoughts?

 

[Guest]

Thanks - that was perfect!
--
Dave L

Add 12 hours with DateAdd("h",12,[YourField])

I have a database where I need to change all current times from AM to PM. In
other words, if I have a field that currently reads 10:45 P.M. ~ I would like
to run a query that would change it to 10:45 A.M.

Any thoughts?