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

mdmartin
mdmartin Member Posts: 10
edited 2006-05-05 in NAV/Navision Classic Client
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

Comments

  • wiro
    wiro Member Posts: 92
    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
    kine Member Posts: 12,562
    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.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Phenno
    Phenno Member Posts: 630
    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
    themave Member Posts: 1,058
    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
    lbink Member Posts: 6
    Check your citrix settings.

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


    Leo
    Leo Bink
    Kick-ICT / KICK Solutions
  • mdmartin
    mdmartin Member Posts: 10
    Thank you for your suggestions.

Categories