Forum Discussion
Skilled SharerWrong input in a field Date
Skilled Sharer
I have repeated the import
= Table.TransformColumnTypes(#"Ordinate righe",{{"DDT issue date", type date}})
Before applying the query, in the column DDT issue date you could find 12/05/2016 22:00:00. Now it is type date but should be 13/05/2016, because this is the data put in the Sharepoint.
Do you have some other suggestion? I did not trasformed yet the column DDT approved date in case we want try something else.
Skilled Sharerthanks to your observation I realized that one of the two columns was wrongly defined.
In fact now I do not need to put DATEVALUE.
Anyway the basic issue of the datetime that come from Sharepoint list remain and I solved it ( temporarly I hope) as shown below.
DDT IssueDateNew = day(('Third Party Delivery Notes'[DDT issue date]) + 1) &"/"& month('Third Party Delivery Notes'[DDT issue date]) & "/"& YEAR('Third Party Delivery Notes'[DDT issue date]) & " "& hour('Third Party Delivery Notes'[DDT issue date]) - 22 &":"& MINUTE('Third Party Delivery Notes'[DDT issue date]) &":"& SECOND('Third Party Delivery Notes'[DDT issue date])
I wonder if someone else has faced the same issue ad how it has been solved.
Thanks again
What is the DateTime format supported by Power BI to push data in that column?
- gpiero
Thank for your message.
The problem arose last May had two variable: the first one my poor knowledge at the beginning, the second one a behaviour the MS support has defined "by design of Sharepoint".
Now I solved temporary the problem using a workaround suggested by MS tech support.
It consist to add some code in the query that trasform properly the field Date manually inserted in the Sharepoint list.
Hi gpiero,
Can you share your solution? I'm facing the same issue importing dates from Sharepoint lists. Both are DateTime columns, but I've 1 day difference like you.
