My date columns are imported as a string column. How do I resolve this?

My date columns are imported as a string column. How do I resolve this?

Do ensure that the column type is set as DATE, DATETIME or equivalent types in the source table. In case your column type is set as string or similar types, then your data column may get imported as a string column. In this case you can convert it into date data type while importing using the Custom Query option. 



    • Related Articles

    • Customize columns

      Customize columns You can customize columns in the issue List view based on your preference. Click  and choose Customize Column. Select Default View or Compact View. Compact View shows more issues than the Default View. Select the desired columns to ...
    • Removing and Reordering Columns

      Admins and column owners have access to remove columns from all users' views. To remove a column: Go to the Monitor tab. Scroll to the column you want to remove and click the ellipsis (...) button in the upper right. Click Remove this column. ...
    • Removing and Reordering Columns

      Admins and column owners have access to remove columns from all users' views. To remove a column: Go to the Monitor tab. Scroll to the column you want to remove and click the ellipsis (...) button in the upper right. Click Remove this column. ...
    • Separate text to different columns

      To change text to columns: Select the required cell or column which consists of the text you want to move to separate columns. Click Data > Text to Columns. The Text to Columns dialog box appears.       3. Choose the delimiters such as comma, space, ...
    • Whom are the imported records assigned to?

      The imported records are assigned to users based on the import option that you select. Import my Records – If you import records using this feature, all the records will be assigned to you. Import my Organization's records – If you import records ...