Forum Discussion
Quotation table date field issue
Hi All
I have a QUOTATION table.
i have problem on how to convert the doc date field to date
Hope some one can help me.
My issue is when i use location to change , it return all null
https://www.dropbox.com/s/6rwm6jj9iiliajs/QUOT_PW.csv?dl=0
Paul
Anonymous
Thank you, I see the sample now. The original text data included date and time, so you can only change the data type to date/time, if you only want the date, you could split afterwards.Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
7 Replies
Anonymous , we will not be able to open data transformation as we do not have source access.
Please share sample data.
Hi Amit
https://www.dropbox.com/s/ma8brqs60wy1kh6/INVC_PM.csv?dl=0
Encloed link for my sample data in CSV .
Paul
Hi Pazhen
Enclosed below my CSV file , and you help me import to PBI can ? hope that you can make the date file in date format.
https://www.dropbox.com/s/6rwm6jj9iiliajs/QUOT_PW.csv?dl=0
Above link is my CSV file .
Paul
Anonymous
Thank you, I see the sample now. The original text data included date and time, so you can only change the data type to date/time, if you only want the date, you could split afterwards.Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
