>I created a table with two fields. Field #1 a character field 25 in length. My second field is a datetime field 8 in length (no other choice for the length). However, when I try to insert a datetime() value into my second field I get a data type mismatch. Can anyone help finger this one out.
>
>Vic

If you want datetime(0 stored change the field type to datetime. If you only want to store the date store date() not datetime to field.

Hth
Jeff