Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Incorrect local date - Australian format

Hi, (Power BI version - Sept 2018 desktop)   I am importing data from SAP BW. I have a date field in the source which imports as text. it comes as dd.mm.yyyy eg for 28th August 2018 it is 28.08.2...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Anonymous,

     

    I found you could change the type in the Data tab. Please do it in the Query Editor that is a data washing tool. You will find it easy now. Please refer to the snapshot below.

    Incorrect-local-date-Australian-format2

     

     

    Best Regards,
    Dale

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks for the tips.

Shouldn't this be considered a bug?

 

My data is from BW, and it imports as text in the format of dd.mm.yyyy

I can tell it is in this format because of the date itself - eg one of them is 30.07.2015

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I guess i'm just too used to fighting against it over the years.  The same problem has always cropped up in other areas too like Excel and VBA.