Forum Discussion

sunjin122's avatar
sunjin122
Helper I
10 years ago
Solved

Changing Data Type problem

I load the data from SQL Sever by using Direct Query. The data type of Date column is Text, so I am trying to change the Text format to Date format, by going to Modeling tab and select the data colum...
  • jahida's avatar
    jahida
    10 years ago

    Basically that's saying that the column you're trying to convert to Date isn't all (valid) dates... Can't help without seeing your data but check for some weird/garbage values and try to filter them out.

jahida's avatar
jahida
Impactful Individual
10 years ago

Basically that's saying that the column you're trying to convert to Date isn't all (valid) dates... Can't help without seeing your data but check for some weird/garbage values and try to filter them out.

sunjin122's avatar
sunjin122
Helper I
10 years ago

Thank you for your advice! It works!

  • asriniva33's avatar
    asriniva33
    Frequent Visitor
    10 years ago

    Hi,

    Could you please let me know of the solution to this issue.

     

    Regards,

    Srinivas

    • sunjin122's avatar
      sunjin122
      Helper I
      10 years ago

      asriniva33 I found out  there is an invalid value in the column. So I deleted it and then everything works

      • asriniva33's avatar
        asriniva33
        Frequent Visitor
        10 years ago

        sunjin122

         

        Thanks for the information.