Date/Time

[klwu]

I have a field [Date] in one of my tables, and the field is set to Date/Time datatype....format is "mm/dd/yyyy"......but when I type in "03/29/2005", I get an error saying that "the value you entered is not valid for the field".....

It was working fine yesterday....but it's not working for today.......anyone know what's wrong with this?

 

[maxmangion]

try renaming your field, because it is not wise to use the word DATE for a field in Access. This might solve your problem.