Change PM to AM

  • Thread starter Thread starter Guest
  • Start date Start date
G

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


KARL DEWEY said:
Add 12 hours with DateAdd("h",12,[YourField])

Dave L said:
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?
Click to expand...
Click to expand...
 
Thanks - that was perfect!
--
Dave L


KARL DEWEY said:
Add 12 hours with DateAdd("h",12,[YourField])

Dave L said:
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?
Click to expand...
Click to expand...
 
Back
Top