Date/Time

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have a qeury field that has long date and time such as 1/4/2007 6:45:05PM
what I need to do is subtract 5 hours from the time, thats it. Is there a
way to do that? The Query is connecte direct to a sql database. I know
enough to not mess with sql directly. Any ideas?
 
John said:
I have a qeury field that has long date and time such as 1/4/2007
6:45:05PM what I need to do is subtract 5 hours from the time, thats
it. Is there a way to do that? The Query is connecte direct to a
sql database. I know enough to not mess with sql directly. Any
ideas?
Click to expand...

DateAdd("h", -5, YourFieldName)
 
I have a qeury field that has long date and time such as 1/4/2007 6:45:05PM
what I need to do is subtract 5 hours from the time, thats it. Is there a
way to do that? The Query is connecte direct to a sql database. I know
enough to not mess with sql directly. Any ideas?
Click to expand...

NewField:DateAdd("h",-5,[FieldName])
 
Back
Top