External data sources 1s, problem with Date Time?

Question

1C

Error: Dates greater than 3999 cannot be used in the query.
External Data Sources
I create a query to the table without parameters, pulling out the first available date of the document 09/19/4014 08:43:17
Well, I think it is necessary to transfer the parameter with an offset of 2000
. , 2000) add an offset. He swears again, but when he tries to transfer it simply without displacement, he does not find anything.
How to fix?!

Answer 1

Well, so use not one parameter, but three - separately day, month and year.
And in the condition write something like this:

ГДЕ ДЕНЬ(Т.Дата) = &День и МЕСЯЦ(Т.Дата) = &Месяц и ГОД(Т.Дата) = &Год