count between dates

[ilanbaruch]

hi all,

I want to count number of transactions from registration date and one week further, for example:(DD/MM/YYYY)

client register in 01/01/2015, I want to count how many trans. he made until 07/01/2015.

thank you

Ilan

[ajsjoshua]

Hi,

Pls go through.

Consider that you have selected 03/12/2105

If you want 01/01/2015 to 03/12/2015, use

SUM({< Year=, Quarter=, Month=, Week=, Date = {">=$(=YearStart(Max(Date)))<=$(=Max(Date))"}>}Sales)

If you want min Date to 03/12/2015, use

SUM({< Year=, Quarter=, Month=, Week=, Date = {">=$(=Min({1}Date))<=$(=Max(Date))"}>}Sales)

[alexandros17]

You can transform a date into a numerical representation with the function Num(myDate), just add to your result the value 7, then simply count your transactions where transaction date is >= Num(DateStart) and <= Num(DateStart)+7

let me know

[tresesco]

Try like:

Count({<MsaterCalDate={">=$(=Only(TransactionDate))<=$(=Date(Only(TransactionDate)+6, 'DD/MM/YYYY'))"}>}transaction)

Assuming your MasterCalDate would be of similar date format ( 'DD/MM/YYYY')