Column not detected as Date

imransaiful17
imransaiful17 Registered Posts: 10 ✭✭✭✭

Hi DataIKU Community.

Does anyone know how to solve this issue.

I uploaded an excel file into DataIKU and there 2 columns which i have already set in the excel file as Short Date. But when it is being imported into DataIKU, one of the column (column name Created) is not detected as Date.

This is causing me problem as I am needed to perform the step 'Compute difference between dates' because the column Created is not detected as Date. Is there a way to solve this?

Refer attached picture of the two columns.

Best Answer

  • fchataigner2
    fchataigner2 Dataiker Posts: 355 Dataiker
    Answer ✓

    Hi,

    you can add steps via the "add a new step" button on the lower left side, and search for "parse date" in there. The steps you get by right-clicking on the column headers are only suggestions that DSS think are most relevant for the column.

Answers

Setup Info
    Tags
      Help me…