why is the date changing ?

  • Thread starter Thread starter hawkins789
  • Start date Start date
H

hawkins789

Having just started this course , i am stuck with my table, when i enter the
date in short it changes to another date altogether, eg. 19/11/07 changes to
19/11/2019 what am i supposed to do to get my dates to stay as what i have
typed them ?
 
Go to the Start button on Windows then go to Settings then Control Panel.

Find the Regional and Language Options. Go to the Regional Options tab. I
bet it says English(United States). That gives you two choices.

1. You need to enter the dates in MM/DD/YYYY format. There is an exception
which you found. You can also enter in YY/MM/DD as a US date. That explains
why your dates get 'flipped', although it should be "19/11/07" changes to
11/7/2019.

2. Change the Regional setting to somewhere that accepts the DD/MM/YYYY
format. This might mess up other programs.
 
Back
Top