Start date to today

[#1]

Hi all,

I have a variable with value as date. I need to get the data from that date to today.

For Ex:

vMinDate = 30/11/2014

count({<DateType = {invitation}, CanonicalDate = {">=$(=vMinDate) <=$(=date(today(),'MM-DD-YYYY'))"}>}invitation_id)

I am not getting where i am wrong in expression.

Regards,

Pramod

[sunny_talwar]

Tried one of these?

=Count({<DateType = {invitation}, CanonicalDate = {">=$(=Date(vMinDate, 'MM-DD-YYYY')) <=$(=date(today(),'MM-DD-YYYY'))"}>}invitation_id)

OR

=Count({<DateType = {invitation}, CanonicalDate = {">=$(=Date(MakeDate(2014, 11, 30), 'MM-DD-YYYY')) <=$(=date(today(),'MM-DD-YYYY'))"}>}invitation_id)

[#3]

Not working

[Anonymous]

Try this:

If you are having like: vMinDate = 30/11/2014

=count({<DateType = {'invitation'}, CanonicalDate = {'>=$(=vMinDate)<=$(=date(today(),'MM/DD/YYYY'))'}>} invitation_id)

[Anonymous]

=count({<DateType = {'invitation'}, CanonicalDate = {'>=$(vMinDate)<=$(=date(today(),'MM-DD-YYYY'))'}>} invitation_id)

[#6]

Hi all,

I am attaching the .QVF file please check and help on this.

you can check in Text & image object the variable enovamindate it's printing different.

Count in KPI should be 4939 instead of 4941.

Regards,

Pramod

[jagan]

HI,

Try like this

let vEnovaMinDate=Date(MakeDate(2014, 11, 30), MM-DD-YYYY);

=Count({<DateType = {invitation}, CanonicalDate = {">=$(=vEnovaMinDate) <=$(=date(Today(), 'MM-DD-YYYY')"}>}invitation_id)

Hope this helps you.

Regards,

Jagan.