Date colunm

[nashr1928]

I am using access 2003 and I already6 have a form tied to a table that has a start date and another with a end date. The dates are already as nov 2011 and when I try and change them to this month and year I get an error. Im not sure what it means.

[Robeen]

It looks like there is an input mask set for the field in question - and that the data you tried to insert into the field is not matching the mask.

I'm guessing that the field is a Date field.
The mask in the error message is 99/99/00;0.
I think it should be 99/99/0000.
Open the table in question in design mode and click on each of the date fields and see which one has an Input mask of '99/99'00;0' and try changing it to '99/99/0000' [without the single quotes].

I hope that helps!!

[nashr1928]

I tried what you suggested but i still get the same error.

[nashr1928]

Correction. I tried to change the date from the input side(the form) I f i change the date at the table it now works fine. Thank you for your assistance. Problem solved.....

[Robeen]

Yes - I did think it would have been in the table.

Happy to help!

Please mark as solved by going to the Thread Tools at the top of this page!!

All the best!