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.

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.