date function

maniram23 — Thu, 13 Aug 2015 06:31:18 GMT

Hi experts,

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 and 07/01/2005 dates. remaining in between of dates it will not show.

same way if i select 01/01/2015 it has to show 25/12/2014 of data and 01/01/2015 of data. remaining in between of dates will not show.

i want show in chart level.

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

any ideas.

thanks in advance

Re: date function

MK_QSL — Thu, 13 Aug 2015 06:38:43 GMT

Replace InvoiceDate with your DateField Name

SUM({<InvoiceDate = {'$(=Date(Max(InvoiceDate)))'}>+<InvoiceDate = {'$(=Date(Max(InvoiceDate)-6))'}>}Sales)