Changing Data Type problem

[sunjin122]

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 · Accepted solution]

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.

[gvg]

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

[sunjin122]

Thank you for your advice! It works!

[asriniva33]

Hi,

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

Regards,

Srinivas

[sunjin122]

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

[asriniva33]

@sunjin122

Thanks for the information.