3 Replies Latest reply on Jan 27, 2014 5:51 PM by malou.puyod

    How can I increment the date (format: 01/27/14) by 7?

    malou.puyod

      I created a calculated field to display my date like this 01/27/14  :

      STR(DATEPART('month',[DATE])) + "/" + STR(DATEPART('day',[DATE])) + "/" + STR(DATEPART('year',[DATE]))

       

      My x-axis is Date which has a format mentioned above BUT my problem is the dates should increment by 7 in which start date is always every Monday.  How can I do this?