Forum Discussion

ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
5 years ago

Help on Date Format conversion

I have 2 Excel files with a Source that has this Column 'Date' (see below) in my 1 Excel it converts fine but in the other it converts it to Month as Date and Date as month see other image below.   ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

ovetteabejuela 

What is the date format in the original excel file, are both date columns are the same data type and format? Can you show a screen short.

 

Paul Zheng _ Community Support Team

  • ovetteabejuela's avatar
    ovetteabejuela
    Impactful Individual
    5 years ago

    In Excel this is in General Type, and it is basically of type Text

     

    Actual Source Screenshot:

     

    Below, I am showing you how it is translated within Excel environment  and into Power Query.