MSSQL varchar data type

fjcortes

when trying to enter data into a form that has several fields DATE type, I get the mistake.
error: Conversion of varchar data type to datetime produced a value out of range

aware_support

Exactly which values are you entering for dates?

fjcortes

aware_support wrote
Exactly which values are you entering for dates?

is when trying to enter the current date through a rule, also on calendar query and query scheduler

aware_support

Yes, but what are the examples of dates you are using?

Also, what is the format of the default representation of datetime in your SQL Server?

Aware IM assumes that SQL Server supports this format for dates:
yyyy-MM-dd

And this format for time:
yyyy-MM-dd HH:mm:ss.S

So if for whatever reason your SQL Server cannot convert from this datetime format, there can be a problem.