i want to get SQL database server date & time and use below coding
but i get error: undefined function "getdate"Code:Set rst = db.OpenRecordset("select getdate() as servertime")
i want to get SQL database server date & time and use below coding
but i get error: undefined function "getdate"Code:Set rst = db.OpenRecordset("select getdate() as servertime")
You'd have to use a pass-through query for that...
https://support.microsoft.com/en-us/...2-6dac62532a42
Thanks Vlad Cucinschi