2 Replies Latest reply on Jun 12, 2017 8:41 AM by Dmitry Beransky

    formatting date range for a label

    Dmitry Beransky

      I want to display a date range as a label for a bar graph.  Can I do better than this:

       

      str(left(datename('month', Min([Start Time])),3) ) + " " +str(datepart('day', Min([Start Time]))) + "-" + str(left(datename('month', Max([Start Time])),3) ) + " " + str(datepart('day', Max([Start Time])))

       

       

      Thanks

      Dmitry