range of the calendar

[Steven H]

Greetings,

I was wondering how far back access can recognize/ calculate days. For
example, is it possible to enter a date from the fourth century AD or even
the fourth century BC?

I thank you in advance for your help and assistance...

 

[Tom van Stiphout]

On Tue, 9 Oct 2007 06:12:00 -0700, Steven H <Steven
[email protected]> wrote:

Straight from the help file:
Valid date values range from -657,434 (January 1, 100 A.D.) to
2,958,465 (December 31, 9999 A.D.). Valid time values range from 0.0
to 0.9999, or 23:59:59.
If you want to do date math outside of that, you'd have to write your
own.

-Tom.

 

[Steven H]

Thanks a lot for you help!

Straight from the help file:
Valid date values range from -657,434 (January 1, 100 A.D.) to
2,958,465 (December 31, 9999 A.D.). Valid time values range from 0.0
to 0.9999, or 23:59:59.
If you want to do date math outside of that, you'd have to write your
own.

-Tom.