Get Server Date/Time

[suoirotciv]

Is there a way that i can get the date and time of the server?

Thanks in advance. ePacific Global Contact Center
Manila, Philippines

 

[Darrylles]

Hi suoir,

Probably, but logically the server should update the client times - no? You then need only refer to the client time knowing it to be correct.
(Pointless implementing multiple client 'time-checking' when the server updates all client times).

Depends on the server op sys of course, but even so - you won't find it difficult to find the software (if not already in NT and Unix servers).

If you NEED this functionality, then look to VB - to be incorporated in Access, Access won't have it.

Regards,

Darrylles
"Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[suoirotciv]

Our company is a call center. And we are based here in the Philippines. But our customers are in the US and Canada. So only the server has the US date and time. In VB its just a simple query that connects to the server ("select current_timestamp as svrDateTime&quot

But it doesn't work with Access. To make it more clearly, I use DSN to connect to my tables to server. I think I just change my question to: "IS THERE A WAY TO CONNECT TO SERVER WITHOUT USING DSN?"

Answers are really appreciated! :-D ePacific Global Contact Center
Manila, Philippines