5 Replies Latest reply on Nov 5, 2018 8:13 PM by Jennifer VonHagel

    Date Ranges (e.g. 1-5 November) in One Column

    Tim Guth

      Hey Guys,

       

      I am having a table as follows:

       

      Start DateEnd Date
      01.11.201803.11.2018
      29.10.201831.10.2018
      28.10.201830.10.2018
      25.10.201830.10.2018
      24.10.201830.10.2018
      28.10.201829.10.2018
      26.10.201828.10.2018
      21.10.201827.10.2018

       

      I want a new colomn with a date range:

      I managed to duplicate it via date functions but combined it as a string ([Month]+"."+[DayStart]+"-"+[DayEnd]) using date functions. However, the sorting is now in alphabetic order, but I want it to sort acording to the actual date (so most recent to oldest). Is there an option I could do this?

       

      Thanks in advance!

       

       


      Best

       

       

      Tim