Knowledge Base Article #202:

Syntax error converting datetime from character string.

Problem: I get an error message when adding a new patient to the PC system.  See title for message.

Reason: The SQL server is picky about the time formats its willing to accept for a datetime field.

 "10/06/2003 2:54:11 p.m." is bad

 "10/06/2003 2:54:11 PM" is good

Solution: In the regional settings of control panel on your machine, on the Time tab, change the AM/PM symbols to all upper case without periods.

Keywords:
Suggestions & Comments
Was this article helpful?
Strongly Disagree / Strongly Agree
12345