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?

    • MarcelBeug's avatar
      MarcelBeug
      Community Champion
      9 years ago

      If you have leading or trailing spaces, select the step before types are changed, right-click the column header - choose "Transform" - choose "Trim" (if it's not there choose "Text Transforms" first and then "Trim").

      You may get a warning about inserting a step but just go ahead and click OK.

    • MFelix's avatar
      MFelix
      Super User
      9 years ago

      Hello Anonymous,

       

      I was looking at you images and noticed that all of the information as the date of 12 January except the first two, are you sure there isn't a problem in the dates or as MarcelBeug refered to regional settings formats?

       

       

      Regards

      MFelix