Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Help - Date format does not work at all

Hi Guys!   I am trying to change the column CSO doc creation date CET - copy into dates (cause it is text right now). However, the result (Date Transf) show me errors in the format and many dates ...
Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago

    Hi Anonymous 

    What is the standard date format in your location is it dd/mm/yyyy.
    What function are you using in "Date Transf"?

    Best Regards,
    Mariusz

    Please feel free to connect with me.
    Mariusz Repczynski

     

  • Washivale's avatar
    Washivale
    7 years ago

    Hi Anonymous ,

     

    you might need to revisit this column in source, I think your function is trying to convert "13th Day" as Month, which will result into error.

    Share more details around how you are getting this data into power bi and how are you trying to convert it to date. 

     

    Thank You,

    Washivale

Mariusz's avatar
Mariusz
Community Champion
7 years ago

Hi Anonymous 

What is the standard date format in your location is it dd/mm/yyyy.
What function are you using in "Date Transf"?

Best Regards,
Mariusz

Please feel free to connect with me.
Mariusz Repczynski