Assistance needed in converting time to est

[Voyager]

Hi team,
I have a table with field name time in general format (5/12/2017 7:05:10 AM) and I wanted the time to convert into est using a query. So I’m trying to apply the dateadd function in criteria row
Dateadd(“h”,-10.5,[time])
Time is the field name in the table which has to be converted
But I’m not getting desired result. Where am I going wrong. Could you assist.

 

[MarkK]

You have not described a symptom of the problem. Without symptoms we have no data to speculate about a cause. This completely disables us from troubleshooting.
hth
Mark

 

[plog]

The second argument has to be an integer. So instead of adding 10.5 hours, add 630 minutes.

Further "time" is a reserved word and shouldn't be used as a table/field name. Instead, prefix it with what the time represents, e.g. SalesTime, MeetingTime, SurgeryTime, etc.

 

[jdraw]

Voyager,
What time zone are you in?

Are you in a small region of Australia near Adelaide?

 

[The_Doc_Man]

Voyager, normally your computer automatically sets itself to the time zone based on the local settings. In fact, for every version of Windows I have ever seen, it asks for your location the first time a new version of Windows is booted. Thereafter, it remembers.

So if you use est to mean Eastern Standard Time, and your computer was first booted in that time zone, your numbers ARE in E.S.T. already.

Therefore, your question lacks some detail that lets us know what you are trying to do. Hence the responses you got that ask questions in return.

Also, word of warning: TIME is a reserved word and you should NEVER name a variable or field to overdefine reserved words. You get confused, Access gets confused, ... never a good thing.

https://support.microsoft.com/en-us...n-access-2002-and-in-later-versions-of-access

 

[Voyager]

Hi all,
Thanks for your immediate attention, I have just attached the sample db which could explain the problem. Kindly check estqy in queries.

Hi jdraw I am in ist and wanted to convert to est

 

[JHB]

Try it now:

 

[Voyager]

Thank you very much JHB and others.
This works fine now.

 

[JHB]

You're welcome.