M
MUSIWA
I would like to write a sub that collects an error from a form and logs the
current user, the error, the date and the time. All of this work but I am
having a hard time getting a way to reference the date and time so as to
store it in my table. I was using access and I upsized to SQL in access the
syntax would be forms(x)!stY = now(). But now in sql getdate() wont work it
says function or sub not defined. If I remove the brackets it works but gives
a wrong date in the 1800 's with no time.
Help
current user, the error, the date and the time. All of this work but I am
having a hard time getting a way to reference the date and time so as to
store it in my table. I was using access and I upsized to SQL in access the
syntax would be forms(x)!stY = now(). But now in sql getdate() wont work it
says function or sub not defined. If I remove the brackets it works but gives
a wrong date in the 1800 's with no time.
Help