Forum Discussion

Kevin Page's avatar
Kevin Page
Copper Contributor
Sep 15, 2017

HELP - converting ODBC data Text Dates

Using ODBC linking, the dates comming over into Excel are in text format "YYYYMMDD".  I have tried every way I can to convert to a numbered date format, but nothing works, even other suggestions in this forum.

 

Does anyone have a recommended solution to this??

BI & Data Analytics
Need Help

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Sep 15, 2017

    Hi Kevin,

    If that's a text you may use Data->Text to Columns selecting on third step of the wizard proper date format (YMD)

     

     

Resources