View Full Version : Date/Time


klwu
03-28-2005, 11:30 PM
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
03-29-2005, 12:12 AM
try renaming your field, because it is not wise to use the word DATE for a field in Access. This might solve your problem.