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 column from the Fields pane, since this cannot be done in Edit Query due to the Direct Query mode. But it didn't work well.  Can someboday help me with this problem? Thank you!

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

6 Replies

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

      • asriniva33's avatar
        asriniva33
        Frequent Visitor
        10 years ago

        Hi,

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

         

        Regards,

        Srinivas

    • gvg's avatar
      gvg
      Post Prodigy
      8 years ago

      jahida

      Yes. But it always should be possible to set type to Text, right? But sometimes Text type selection is greyed out - don't know why ...