Dynamic Date Comparison

[#1]

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

[lironbaram · Accepted solution]

hei check the attach example

i added a varaible of days diff

and used it in thep previous expression

[#3]

Hi Liron,

Thanks so much for the help, works perfectly!

Matt

[#4]

Hi Hope this helps!

PFA