Date Field

[LindaCoedy]

I have two tables in the database, both with date fields. I have set up an
input mask of day/month/year in both. In one of the tables I am able to
enter this way but the other table is changing to month/day/year even if I
enter it as day/month/year. That was the first problem. Now after entering
dates in the second table that is not working correctly, I can not add dates
at all. It just stays blank. Is this a bug or problem? It seems funny when
they are set up exactly the same way and time that one table is working and
the other is not. Please help. Thanks.

 

[Allen Browne]

Remove the input mask. It does nothing but clutter up the entry.

Also remove anything in the Format property so you don't get inconsistent
displays.

For an explanation of how to work with dates in Access in a d/m/y country,
see:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html

 

[LindaCoedy]

Thanks. I removed the input mask and everything is working perfectly.