Problems with MDY function

[Anonymous]

Hi,

I have this expresion in a graph:

sum( { <fecha={"16/05/2015"}>} venta)

It works OK

but next expresion doesn't

sum( { <fecha={"Date(MakeDate(2015,5,16),'DD/MM/YYYY')"}> } venta)

It doesn't work, It doesn't find rows, and is the same filter as first expresion

Can anybody help me???

Thanks

[sunny_talwar · Accepted solution]

Try this:

=Sum({<fecha={"$(=Date(MakeDate(2015,5,16),'DD/MM/YYYY'))"}>} venta)

HTH

Best,

Sunny

[#3]

sum( { <fecha={"=Date(MakeDate(2015,5,16),'DD/MM/YYYY')"}> } venta)