My CSV file Posting Date how to convert to Date ?

[Paulyeo11]

Hi All

I have a CSV file , the posting date , after import to PQ , i try to convert it to Date , all date become error. i also try to convert to US date , it also not working. Hope you can help me to import to PBI , and let me know how to make it become date ?

https://www.dropbox.com/s/1326cuvkjirs9co/GL_TS.csv?dl=0

I Try by import using CSV file format.

Paul

[v-zhenbw-msft · Accepted solution]

Hello @Paulyeo11 ,

Maybe the structure of your date can't change to the U.S. date.

You must right-click the date column and select Change Type -> Using Locale.

Then choose English (World).

Best regards

Community support team _ zhenbw

If this post helps,then consider Accepting it as the solution to help other members find it faster.

[Paulyeo11]

Hi Zhen

Thank you vry much for your sharing , yes you are correct , i make a mistake to change the date to USA date , which is wrong . instead i should use UK date .

If this world all just using one standard date , i think it will be less problem , but that is not possible.

Paul 

[Ashish_Mathur]

Hi,

It imports just fine for me.

[Paulyeo11]

Hi Ash

thank you for sharing , I will try again .