title: How to change data type to Date/Time using direct query mode
body: <p>When i want to use a Date column in this mode it shows as a Varchar/string type. So, when i try to change it from Direct Query it accepts the Date Format, but the DataType still remains as a Varchar/STR. I need to create some Time Intelligence formulas (Basically a DateDiff).</p>
  <p>Any idea how to solve this?</p>
  <p>Thanks!</p>