5 Replies Latest reply on Feb 28, 2017 11:34 PM by Leanne Vermeulen

    How to Show "DD Month" string/format using Date (excludes Year)

    Leanne Vermeulen

      I apologize if this seems obvious but I cannot find info for this online! I can convert a date part into a custom DD/MM/YYYY format, but is there a way to display it as DD/MM only, without YYYY? I've tried using this calculation but the second part is flawed, as it considers the 'month' datepart as an integer before converting it to a string, not a month in terms of text:

       

      STR(DATEPART('day',[Date])) + " " + STR(DATEPART('Month',([Date]))

       

      So I get his result: "24 2" instead of "24 February". The example below is using the Custom Date format DD/MM/YYYY.

       

      Date Format.png

       

      Thanks!