8 Replies Latest reply: Feb 18, 2016 7:38 PM by jagan mohan rao appala RSS

    How to display the week date range on the X Axis of a chart?

    Emmanuel Robles

      I am trying to replicate a report produced in excel where the chart displays the date range for the weeks of the year. For example if I wanted to show the date range for week 2 I would want to show 1/3/2016-1/9/2016 and so on. I have included a snapshot of what it is I'm trying to replicate. The expression suggested for to use is =dual(WeekStart([Date]) & ' - ' & WeekEnd([Date]),[Week Number]) however I would like to be able to script it as a part of my calendar.