I have some code behind a button in Access. One of the tasks it completes is to add the current date in one of the fields. It isn't working. It adds random dates. Instead of 9/29/11 for today's date, It returns 9/10/11. I have confirmed that my system time is correct. What is wrong with this statement?
rs!PullDate = Date
I tried to write it as rs!PullDate = Date(), but VB removes the ().