When I create an insert statement that contains a date,
it is usually inserted into the sql server db as mm/dd/yyyy but when I pull up the same date for update, it is displayed in this format:
dd/mm/yyyy.
As a result, if I have a date that was inserted into the db as 02/13/2003, when I want to update the field, it displays as 13/02/2003.
This is causing this error:
][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
Can someone please tell me how I can resolve this?
Thanks in advannce
it is usually inserted into the sql server db as mm/dd/yyyy but when I pull up the same date for update, it is displayed in this format:
dd/mm/yyyy.
As a result, if I have a date that was inserted into the db as 02/13/2003, when I want to update the field, it displays as 13/02/2003.
This is causing this error:
][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
Can someone please tell me how I can resolve this?
Thanks in advannce