Re: Unsure why VBA thinks dates entered are greater than Now() - when they are not?
- From: "Larry Linson" <bouncer@xxxxxxxxxxxxx>
- Date: Mon, 06 Aug 2007 05:21:33 GMT
"SmartbizAustralia" <tom@xxxxxxxxxxxxxxx> wrote
THe problem is that Access only thinks in American
format but stores it anyway you want.
Actually, that is not the case... all date/time values in Access are stored
the same way, regardless of the Regional Settings -- that is, a date/time
field or variable is the equivalent of a Double Precision Floating Point
value with the integral (or whole number) portion representing days since
Dec. 30, 1899 and the fractional portion representing time since midnight.
The Regional Settings only affect how date data you enter is interpreted and
how stored date data is displayed.
The problem you encounter is that there are some situations in Access and
the Jet database engine which ignore the Regional Settings.
(YMMV on date data kept by other applications or by Windows itself.)
Larry Linson
Microsoft Access MVP
.
- References:
- Prev by Date: Re: Grouping by weeks
- Next by Date: Re: Editing disabled by alternative to INNER JOIN
- Previous by thread: Re: Unsure why VBA thinks dates entered are greater than Now() - when they are not?
- Next by thread: Re: Unsure why VBA thinks dates entered are greater than Now() - when they are not?
- Index(es):
Relevant Pages
|
