The time and Date is read from your Computer - I am sure you have checked for the correct time and date.
What are you getting as an example of "the wrong date". Is this within VBA code or in a field within a form or report?
If you are using any kind of format statement, make sure you are using the correct format. For more details check out: http://office.microsoft.com/en-ca/access-help/format-function-HA001228839.aspx
As well, I too had issues with the date function a while back and it was because I was using a non-USA locale (Canada English) where we show our date as DD/MMM/YYYY. However, the US locale displays info as MMM/DD/YYYY. I believe, if I recall correctly, I could not resolve this until I set my PC for US Locale in the control panel under "regional and language options" - make note of your setting before you make any changes.
Hopefully this helps.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 3.
