how to get Server date?

Hi,

what do you need it for? I do not know any way to get the server date at the client in Navision.
There might be some workarounds.

creat this view on the ms sql in your Navision Database:

CREATE VIEW dbo.ServerDateTime_View
AS
SELECT '' AS PK, GETUTCDATE() AS ServerDateTime
ORDER BY ''

Create new table in Navision with same name as the view (you can use another
name in the view),
create two fields:

1 PK Code 20
2 ServerDateTime DateTime

Set properties:
DataPerCompany = No
LinkedObject = Yes

Save the table. If you make SDT.GET; (SDT is variable of type Record for
your new table) you have in field SDT.ServerDateTime the server date and
time...

The field PK is there only as simulation of Primary key to be able to make
GET for this table...

Or, if tables are hard to find, you could try a little Automation code... (adoRecSet is 'Microsoft ActiveX Data Objects 2.8 Library'.Recordset)

CREATE(adoRecSet);
adoRecSet.open(
  'SELECT CONVERT(char(25), GETDATE(), 126) AS ServerDateTime',
  'Provider=SQLOLEDB;Server=(local);Trusted_Connection=Yes');
theDateTimeString := FORMAT(adoRecSet.Fields.Item(0).Value);
CLEAR(adoRecSet);

MESSAGE(theDateTimeString);

Of course, you must change 'Server=...' to the name of your SQL server...