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

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

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

any ideas.

thanks in advance

[sunny_talwar]

Where does it need to go back 7 days? In a chart? In a text box object? In script? Please provide more details for a better response.

Thanks,

Sunny

[maniram23]

Hi it has to show in chart.

[sunny_talwar · Accepted solution]

May be this within your set analysis statement:

{<Date = {"$(=Date(Max(Date) - 7, 'YourDateFieldFormat'))"}>}

[#5]

Hi Mani,

Ya The above one will give the result

{<Date = {"$(=Date(Max(Date) - 7, 'YourDateFieldFormat'))"}>}