RPA Center error varchar to datetime

Hello!

RPA Center gives me the following error:

“The conversion of a varchar data type to a datetime data type resulted in an out-of-range datetime value”

How can I solve this?

I think so.
I guess the database does not support the ISO date format (yyyy / mm / dd).
The quick way is to configure the user date format that you use in RPA Server to log in to the SQL Server. Watch the command in the help of the SQL Server and tell us if it works, and the command that you used.

Hi!

I finally changed the base language of the SQL Server user to English instead of British (that was the default language), so I could bypass the ISO limitation. It worked perfectly!

I just needed to execute:
ALTER LOGIN <user_name> WITH DEFAULT_LANGUAGE = English;