Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Change date display format

  Hi,   My Date is in format 01/09/2017 00:00:00 ie (DD/MM/YYYY hh:mm:ss) as below:   DataTime 01/09/2017 00:00:00 01/09/2017 00:30:00 01/09/2017 01:00:00 01/09/2017 01:30:00 0...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi Anonymous,

     

    Just add a column to your data with the following syntax:

     

    Date_Time_Format = FORMAT('Date'[DataTime],"DDD DD hh:mm")

     

    Regards,

    MFelix

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

You are going to have to create a new column that uses a combination of WEEKDAY, SWITCH, CONCATENATE and FORMAT functions.

 

Something like:

 

Column = var wday = WEEKDAY(Events[EventTime])
var wdayname = SWITCH(wday,1,"Sun ",2,"Mon ",3,"Tue ",4,"Wed ",5,"Thu ",6,"Fri ",7,"Sat ")
RETURN CONCATENATE(wdayname,FORMAT(Events[EventTime],"dd hh:mm"))

 

Update: The other solutions work as well although not documented here:

https://technet.microsoft.com/en-us/library/ee634398(v=sql.130).aspx

 

I would disagree that it is not possible to just change the display format, you can do that in the Modeling tab by having a data type of Date/Time and changing the Format via the dropdown. But, there is no choice for your particular format.