Profile || The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

Error while click on Profile Button -- The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

            

Solution -For this issue you are requested to change the Date format of the system.

Process : Change Date Format in Customize Format Control Panel

Open the Control Panel, and click/tap on the Region icon.

            

In the Format tab, select >> English (United States)

            

Now, click/tap on Additional settings. (see screenshot below)

            

Perform the following actions: (see screenshot below)

Click/tap on the Date tab.

In the Short date - Fill dd/MM/yyyy

            

Click/tap on OK.

• Related Articles

• TDS Correction Excel Import "Error converting data type varchar to numeric"

  TDS Correction Excel Import Error:- 2147217913 Error converting data type varchar to numeric Possible Resolution To solve this excel import issue, here are some suggestions are given below.  1. In the Excel template, it is to be checked that the ...

• How to recover data through .kbu Files?

  Data restoration through .kbu files. KBU Files contains the data Spectrum (Excluding TDS). For restoration of data please follow the steps below: Step 1: Go to C Drive > Windows > Here check the files extension > .kbu                 Step 2: Copy ...

• TDS validation error - Invalid value in the field Deductee/Party records or value not as per file format

  TDS validation error - Invalid value in the field Deductee/Party records or value not as per file format Solution  This error would be come when we import the data from Excel template and change the predefined field in the Excel template. To solve ...

• Invoice & other data upload for creation of GSTR 1

  The table below provides the name, full form and detailed description for each field of the worksheets followed by a detailed instruction for filling the applicable worksheets. The fields marked with asterisk or star are mandatory. B2B B2B Supplies ...

• eXBace Data back up and Data restore

  Whenever the user wants to format the system or change his system to other, there would be requirement to take proper data backup of the software so that the data is not lost. eXBace SAAS: Please note that you cannot take data backup of Exbace SAAS ...