3 Replies Latest reply: Jan 25, 2012 5:47 AM by Erika Jain RSS

    Dynamic Date Comparison

      Hi,

       

      I've set up a date selector that allows users to enter a to and from date for which data will be displayed. I would now like to make a comparison between the date range they've entered and the previous period relative to this date range. For instance, if they enter 12/20/2011 to 12/30/2011, I would like to show the figures for 12/9/2011 to 12/19/2011 in another column.

       

      I've seen similar things done with the addmonths fuction, but have not been able to find a way to do it with days.

       

      I've attached the example I'm working with. If anyone has any insight, it would be greatly appreciated.

       

      Best,

       

      Matt