How to create expression to select data based on date range?

[#1]

Hi,

can anyone suggest me please. as I need to show data from last Week Friday to current week Thursday.

suppose today is 13/11/2014 I need to show data from 07/11/2014 to 13/11/2014. so, it should happen for any week for example if the user select data from Friday to Thursday in last month the data should change based on selection.

How can I create expression Please help

How to change below expression

Count({$<DateType={'Logged'}>} Distinct CustomerID)

Thanks.

[#2]

can anyone suggest me please

[#3]

Hi

Try this Here your current date is 13/11/2014 that is today.

let vcurrdate=today();

Count({$<Date={'=<($(vcurrdate) >=(($(vcurrdate)-7))'}>}  CustomerID)

[Anonymous]

You have to write expression using "date(weekend(today())-9)" which will give you last friday and "date(weekend(today())-3)" which will give you this week thursday