Convert from UTC quick and dirty 1

[mlocurci]

I need a one time fix so that I can have a query to look at the timestamp in a table that is UTC and adjust it for EST (-5). I am somewhat perplexed and know this should be VERY easy, but I am confused. Help Please!

 

[Remou]

You can use negative numbers with DateAdd.

 

[mlocurci]

Understood, but the data is static in the table.

I ideally I want a field in my query that says

EST_TimeStamp:[CaseAdd]-5

 

[Remou]

I had visualized:

SELECT t.CDate, DateAdd("h",-5,t.[CDate]) AS Minus5h
FROM t

 

[mlocurci]

Still can't get it. I really just want to recalculate the date by 5 houts in the past. I am just stuck with how to do it.

 

[mlocurci]

Ereka! I see the error of my ways

DateAdd("h",-5,[Case_Open_DT])

 

[JoeAtWork]

I'll give you a star for that, Remou.

 

[Remou]