Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

We cannot convert the column automatically to Date Type

I have a date column with values as 2014-11-08 08:58:30.3 format. I am trying to convert the value as 2014/11/08 because i need to use Power bi custom Timeline slicer and it takes date in this format...
Data Modeling
  • McCow's avatar
    McCow
    8 years ago

    Hi Anonymous

    you can try convert the data column manual, as text field in Query Mode like this

     First split column, then convert. If you don't need a time - remove it at last.

     

    And HERE is full example

     

    You can see, yours text date field was correct converted to DATE

     

    Best regs

McCow's avatar
McCow
Resolver III
8 years ago

Actually not, but I duplicate the file yet HERE

prasa's avatar
prasa
Helper I
8 years ago

MC - Thanks for the link :) Actually in my case the text column is in this format: 

2018-03-07 10:07:04 EST

 and need to convert to date time. I am able to split the column to 2 and convert the first part to date. How do I convert the second one to time? 

 

Advanced thanks for the help. 

 

 

  • McCow's avatar
    McCow
    Resolver III
    8 years ago

    Hi prasa!

    Actually, once what you need is split your column twice. Or better one column to three.

    Please, look on example. PQ make this semiauthomatic.

    And will be nice if you create new ticket with new relevant solution.

    Best regs.