Date Problem

[Fainja]

Hello,

I have problem with date in acces 2010. I dont know why the date look like this: 15/04/17105.


Why the Year is not 2017 but 17105??

if someone has seen before this problem let me know how to fix it.

Thnx

[CJ_London]

date is a form of decimal number which is formatted as you require. The value to the left of the decimal point represents the number of days since 31/12/1899.

So either your value for the date is huge (today is 42840) - circa 600000 or your formatting is wrong