I tried to manually change a few fields in my table that originally had datatypes of "varchar" to "datetime". I am hoping that by converting to datetime, then I can display specific records in a range according to dates. However, when I went directly to my table and changed the value type of the field, authorization was denied. I got the following error messages:
1) Data may be lost converting
2) Then when I click okay, I get the following:
3) 'BBDirectory_BPD (dbname)' table
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting datetime from character string.
How can I successfully convert the datatype from varchar to datetime?
Thanks in advance.