select date range

[#1]

Hi all,

I have data before 11-30-2014, but i need to select data after that date so i am using below expression.

It,s not working please help on it.

Let vEnovaMinDate = 11-30-2014   {initializing variable }

count({<DateType = {invitation}, CanonicalDate = {">=$(date(=vEnovaMinDate))<=$(=max(date(CanonicalDate)))"}>}invitation_id)

can anyone help where i am going wrong

Regards,

Pramod

[MK_QSL]

Try

Count(

     {<

          DateType = {'invitation'},

          CononicalDate = {">=$(=Date(Date#(Min(vEnovaMinDate)),'MM-DD-YYYY'))<=$(=Date(Date#(Max(vEnovaMinDate)),'MM-DD-YYYY'))"}

     >}

invitation_id)

[#3]

always format date inside the variable, don't use any function directly in set analysis. After that,

CononicalDate = {">=$(vEnovaMinDate) <=$(vEnovaMaxDate)"} should work.

Important: Don't forget the white space between two variables.

[#4]

I am using like below it's wrong?

CanonicalDate = {">=$(=vEnovaMinDate) <=$(=date(today()))"}

because i need count till today from the start date.

But above is not working.

[#5]

wrong:  $(=vEnovaMinDate)

right:  $(vEnovaMinDate)

vEnovaMinDate variable must start with equal sign.