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]

What is the format of your CanonicalDate field? Is it DD/MM/YYYY (which you have for vMinDate) or MM-DD-YYYY which you use for today??

Both of these formats need to be the same and need to match the format for CanonicalDate field.

[#3]

Yes all in the same format "MM-DD-YYYY"

let vEnovaMinDate=11-30-2014;

Is it correct way to assign the date to variable?

[Anonymous]

Try this:

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

[sunny_talwar]

Try this;

=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)

[Kushal_Chawda]

Create variable as

vMinDate = date(date#('30/11/2014','DD/MM/YYYY'),'MM-DD-YYYY')

Now try your expression ,it should work

[#7]

Thanks for the reply, not working,

I think i am posted the same expression above except "".

[Anonymous]

As already shared the expression, use single quotation for invitation like 'invitation':

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

copy and paste this expression

[#9]

Sorry not working,

why we need to define like that,

we can directly define like 30-11-2014 right?

[#10]

Yes i tried but not working.

I think my declaration is wrong, because i tried to print it in text box their also i am not getting output