Repost from another forum

[ictcrystal]

I havent had much luck with this question so im going to post here

---

Hello,

I Have a field called appointment date and i have set the input mask as short date 00:00;0;_

the data type for the field is date/time but for some annoying reason this error message appear when i enter a date to the table... which for example is written like this 01/03/2003

so im not writing it in the wrong way

ive attached the msg below

Any help would b nice


Attached Images

[CJ_London]

cross post here OP allowed 48 minutes for a response

http://www.access-programmers.co.uk/...=1#post1419730

[Missinglinq]

The Input Mask for a Short Date is

99/99/0000;0;_

not

00:00;0;_

and you really need a little patience! All of these forums are manned by people who are donating their valuable time to help, and you're not necessarily going to get a response within an hour, especially on weekends/holidays.

BTW, the correct Input Mask could have been easily generated using the Wizard by clicking into the Input Mask Property box and then using the dropdown to select the proper one.

Linq ;0)>