Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Date format error

Hello everybody,   when I update my input file PBI returns me an errore about Date Format. The problem is that it returns me that error only on a specific value, whereas it's able to convert all th...
Need Help
MFelix's avatar
MFelix
Super User
9 years ago

HI Anonymous,

 

Sometimes I have this issue and what happens is that the specific cell as one space or some other carachteristic like that in the end doesn't allow to make the conversion, although in the data source everything is OK. Try to copy the value and compare all the caraters with another value that converts ok.

 

To check this please add a custom column to your output and then place the following formula

 

= try[Date] 

 

This formula will "try" to do the formating and return you the the detail information about the error please check the print below, probably this will not give much more information than you already have but it's worth a shot, and as I said also check if you don't have any additional carachter in that specific record.

 

 

Any question please tell,

 

Regards

MFelix

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hello MFelix,

 

thx for your reply. I applied the steps you suggested and I got the same as you. Here come my question, hos do I fix this?