Column Datatype Lost in querytable
Hello,
Can someone from Zoho please doublecheck this?
How to reproduce the error
I have a Zoho Report table with multiple columns, I will call it "TableX"
One of the columns is a "Date" datatype with formatting example "13 Jan 2011 00:00:00"
If I create a Zoho Chart and drag this Date column into the filters, I can use it as a range with "from" and "to"
(This filter is great because I have over 100 distinct date values and need to select any of them)
I now create a new query table with T-SQL statement
SELECT *
FROM TableX
Problem
- The date column in the result set returned by Zoho is now a "Text" field
- I can not create a Zoho Chart with the "from and "to" filter (This is my main concern)
Note:
- I have tried various commands like CAST( mydate AS date) with no success
- I think all columns are returned as text fields (?)
Am I doing something wrong?
Is there a solution?
Kind Regards,
Scott