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

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

Please do it in the Query Editor. 

We_cannot_convert_the_column_automatically_to_Date_Type2We_cannot_convert_the_column_automatically_to_Date_Type

 

Best Regards,

Dale

  • McCow's avatar
    McCow
    Icon for Resolver III rankResolver III
    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

    • prasa's avatar
      prasa
      Icon for Helper I rankHelper I
      8 years ago

      The link provided is broken.. Can you please update the link ?

       

      • McCow's avatar
        McCow
        Icon for Resolver III rankResolver III
        8 years ago

        Actually not, but I duplicate the file yet HERE