help with dates

Business Central/NAV Technical Forum
1

hi everyone…how can i get the server date in navision? thanks in advance

2

Check http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=9050&SearchTerms=get,server,date for some ideas.

3

thanks

4

Well, We have few clients running on SQL, who gets the Server date & Time. We have written a SQL View on the Server and we have a table with the same name as view in Navision. Structure will be like this: Table: (Date_Time) Primary Key Code 10 Server_Date Date Server_Time Time Codeunit: (Date_Time) Two New Functions 1) GetServerDate() [Return type is date] SELECTLATESTVERSION; IF NOT DateTime2.GET THEN rstDate_Time.Server_Date := TODAY; EXIT(rstDate_Time.Server_Date); 2) GetServerTime() [return type is time] SELECTLATESTVERSION; IF NOT rstDate_Time.GET THEN DateTime2.Server_Time:= TIME; EXIT(rstDate_Time.Server_Date); You can simply call the codeunit finction to get the server date & time. Have fun. Naveen Jain