date function help

[maniram23]

Hi,

   i have one date field in my data.and some id,sales of data is there.

here if i select any date it has to go 7 days back for example

if i select 07/01/2005 it has to show 01/01/2015  & 07/01/2005 date.

same way if i select 01/01/2015 it has to show 25/12/2014  & 01/01/2015 data .

i have some ideas but those ideas are not giving proper result.

any ideas.

thanks in advance

[sinanozdemir]

Maybe something like this:

In order to achieve this, I used the below script for expression:

And the below script for the label:

I am also attaching the qvw.

Hope this helps.

[Anonymous]

Hi,

Try this

=num(today()-7)