Forum Discussion
Issue with date field in direct query mode
Hi , I have 2 tables-Table A and Table B that are joined by fileid column. I am displaying the data in Table A in a table chart. In another table visual I am displaying the data from Table B. My aim...
I wrote a sql query for Table B, and converted the date field to varchar.. Strangely it worked after converting the date field to text.
Regards,
Priyanga
@Pranit, Query editor has detected it as a datetime field. Its not in text
I wrote a sql query for Table B, and converted the date field to varchar.. Strangely it worked after converting the date field to text.
Regards,
Priyanga