This content has been marked as final. Show 3 replies
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.