Code to use the Server Time and not the Client Time?

mdmartin

Hi

A clients users are connecting to a 3.70 SQL Server via Citrix from different time zones and are running reports which calculate a ‘time total’. Naturally different values are being returned (due to the time difference). Microsoft Dynamics have stated that Navision is not designed to use the server time, only client time and they cannot provide a resolution. They have made a suggestion regarding Citrix but this is not appropriate in the circumstances.

Does anyone know of a command / code that can be used to force a report to use the Server Time and not the Client Time?

Thanks

Michael

wiro

Hi

I'm sorry for my ignorance.
You can try to make your own table that save date and time on server and the table can be access by client.
Or you can access through SQL Server if you use it as database via store procedure.
I hope this can help.

kine

May be you can try to not use date and time fields but datetime fields. Datetime is timezone dependent. But I am not sure if it is just for MS SQL server or on Native DB server too.

Phenno

Or you can try to simply calculate date/time like it is calculated on this forum for example.

Give to users option to choose time zone, create codeunit or somehting that will calculate time on the "server" and than applicate that code to wherever you want.

Ofcourse, you will have to watch out for few details, What is reference time (Zero zone), Cause you have client time, you will have to reverse calculating from normal, To watch out for timezones that does not have summer/winter tima differences, etc...

themave

since they are connecting to citrix server, can you just sync the citrix servers to the database server time, using the nettime command, then the client will match.

lbink

Check your citrix settings.

You can tell citrix to use the clients time and timezone for every session. Navision client will follow.


Leo

mdmartin

Thank you for your suggestions.