Error inserting Date from date picker

Savvy · Post by **Savvy** » Thu Mar 19, 2015 1:38 pm

Hello,

I seem to be having issues when inserting a date selected from a date picker control.

The SQL 2012 column has the Date format, ASP.net maker is set to validate the value inserted as 'DD/mm/yyyy'.

Everything works just fine when inserting a single record, it is when doing a grid insert or a bulk update that problems arise. below is the error message that is generated.

Conversion failed when converting date and/or time from character string.

I hope someone could direct me to the problem.

Savvy · Post by **Savvy** » Thu Mar 19, 2015 1:56 pm

Ok so to answer my own question....

I ran the following query:

ALTER TABLE [table]
ALTER COLUMN [column] DATETIME NULL

This is to change the column from DATE to DATETIME. I re-ran asp.net maker to update the project after the change then generated.

now everything works fine, seems that there is a limitation with the DATE date type column.

Post by **Webmaster** » Sat Mar 21, 2015 9:24 am

You are probably using the [Database type] = "Microsoft SQL Server" which may detect the data type incorrectly. Always use "Microsoft SQL Server 2005/2008/2012" to load database >= Microsoft SQL Server 2005.