Date input mask question for A2K

[YACHTIE]

All,

Currently I have numerous date columns in various tables that all use the following input mask: "99\->L<LL\-00;0;"

What i would like to do is force the user to use the day-month-yr format (only in Canada)which is currently left to either day or year first.

Was thinking the easiest would be be to change the 2 zeros to 4 zeros (-0000;0 at the end of the mask.

Is that correct and what if anything will be the impact of this change on the existing data in the tables?

There is a lot of interaction between these various databases which makes it rather difficult to predict the total impact as I can not isolate all from the production database.

TIA

 

[SkipVought]

Hi,

The Input/Display FORMAT has nothing to do with the underlying DATA, which is a pure number. Dec 31, 1899 has a value of ZERO, and today's date is the number of days since Dec 31, 1899.

Skip,
[sub]
[red][/red]
[/sub]

 

[YACHTIE]

Skipvought,
Thanks for the comment, I knew that Access converts the dates into integers but that still does not solve my dilemma in that I have dates data that is faulty, for what reason I do not yet know. Either thru operator error or programmatically.
Reading this post now however I had a thought: Can I write a macro or query to weed out or isolate any date values > today easily?

If so how do i accomplish that?

 

[SkipVought]

Where [DateField]>Date()

Skip,
[sub]
[red][/red]
[/sub]