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
az38's avatar
az38
Community Champion
6 years ago

Hi Tgilchrist 

Just curious, why is this such a problem?

anyway, try to play with CAST or CONVERT

I think

CAST(Timestamp as nvarchar(10))

could help you

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.