Forum Discussion

Tgilchrist's avatar
Tgilchrist
Frequent Visitor
6 years ago
Solved

SQL column as Date type format converting to Date/Time during Query Editor Import

Hello all,    As stated in the subject I'm having an issue with a SQL column formated as a Date type being recognized by the Query editor as Date/Time.    I have already disabled both "Auto date/...
Need Help
SusieN's avatar
SusieN
Regular Visitor
5 years ago

This does cause a problem when you want to use the date field with slicers or as values in tables - having the redundant time element is just messy and looks as though you can't be bothered to format properly.  Where in reality I can't find a way to format to just date.

mwegener's avatar
mwegener
Most Valuable Professional
5 years ago

Hi SusieN,

I had a similar problem this week.
May I ask what is your data source?
I have not been able to test it yet, but hope to solve it using the "Date Only" transformation.