Forum Discussion

AlexHolmeset's avatar
AlexHolmeset
Icon for Helper III rankHelper III
8 years ago
Solved

Change date format?

SQL store the dates as yyyy-dd-mm(collumn is string and not datetime): Power BI shows the date as mm-dd-yyyy(i have for testing coppied the data to excell and set the collumn as date format): ...
Need Help
  • AlexHolmeset's avatar
    AlexHolmeset
    8 years ago

    I set this on top in my insert sql query:
    SET DATEFORMAT dmy;

     

    now its working as it should :-D

MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
8 years ago

You should be able to set this in the modelling ribbon, date format 

  • AlexHolmeset's avatar
    AlexHolmeset
    Icon for Helper III rankHelper III
    8 years ago

    like this? It still reads as mm-dd-yyyy.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      You could change the locale in option.

       

      Go to options and regional settings and select your choice.

       

      If it still doesnt work after you have changed the format in modelling tab, do an explict conversion in SQL e.g (CONVERT(Varchar, Date, 102).

       

      Regards

      Yomi

      • AlexHolmeset's avatar
        AlexHolmeset
        Icon for Helper III rankHelper III
        8 years ago

        Thanks for the replies.  Change region to english(united states) but still the same. 
        Il take a look at converting in SQL.