Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Stuck on a date issue

I've done an import from Salesforce and unfortunately, SF is sending over dates with multiple formats for the same column - as Text.  In Excel, this is fixed by simply selecting the entire column, do...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Anonymous,

     

    After loading the date field into desktop, please refer to below steps to convert its date type.

     

    Open Query Editor. Split column by delimiter "/".

     

    Add a custom column to combine them with a supported format.

    =Text.Combine({Number.ToText([Date.2]),Number.ToText([Date.1]),Number.ToText([Date.3])},"/ ")

     

    Set the data type for custom column to Date.

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Anonymous,

 

After loading the date field into desktop, please refer to below steps to convert its date type.

 

Open Query Editor. Split column by delimiter "/".

 

Add a custom column to combine them with a supported format.

=Text.Combine({Number.ToText([Date.2]),Number.ToText([Date.1]),Number.ToText([Date.3])},"/ ")

 

Set the data type for custom column to Date.

 

Best regards,

Yuliana Gu