Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous - That's odd, are you sure that when you add the date column that it is preserving the relationship between the two tables? If you field is not a date in Direct Query mode, you will need to fix that on the database side of things.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Greg,It is already in datetime datatype in SQL DB