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

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

An error occurred when clicking the "Profile" button or during "TDS Return Filing" → 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 ...

    • 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 ...

    • ExpressITR || Capital Gain Data Feeding Process

      Follow these steps to efficiently input capital gain data for a client in the Express ITR application: Step 1: Access the Client Profile Open the client’s profile and navigate to the ITR Summary section within the profile. Click the button under ...

    • eXBace || Data import and export through excel

      To reduce complications of data entry In eXBace software, a facility has been provided where the user can import data through excel and can export data in excel. The User can also validate every sheet where the data is entered at the same time. The ...

    • Income Tax || Export and Import Capital Gain Data via Zerodha Excel Template

      Steps to Export and Import Capital Gain Data via Zerodha Excel Template Exporting Capital Gain (Tax P&L) Data from Zerodha Step 1: Access the Tax P&L Section Log in to your Zerodha account. Click on the Reports tab. Step 2: Select Tax P&L Choose the ...