Share via

Access 2013, wrong year display

Anonymous
2015-03-24T14:20:41+00:00

I am using access 2013, through office 365 licence.

I am facing the following problem

  • I create a new blank database and I create only one table with one field: date field named FromDate.
  • I open the table for data entry and I try to enter the date in my first record. when I use date picker and for example if I select January 1st 2015, I will get in my field 1.1.20151

It seems that the number of days in a year has been concatenated at the end of the year string

Jan 1st  2015, year is 20151

Feb 1st  2015, year is 201532

Nov 1st 2015, year is 2015305

Smiljan Pilipović

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2015-03-24T19:02:28+00:00

What is the system short date format in Windows Control Panel?  I would not be surprised if this has the additional 'y'.  By default Access uses the system short date format.

Was this answer helpful?

0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-03-24T19:33:59+00:00

    that was the problem! thanks!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2015-03-24T18:16:26+00:00

    This was the first thing that I suspected, but the Format setting is empty.

    If I open format setting, as the General Date example, I see 12.11.2015316 17:34:23

    But, again, that field is blank.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2015-03-24T15:53:45+00:00

    I suspect you have an incorrect Format setting for the field in the table definition. Is it perhaps using a format such as

    d.m.yyyyy

    with FIVE y's instead of four?

    Was this answer helpful?

    0 comments