Set Expression on Date not working

[cristian_av]

Hi

I have a set analysis expression that is always giving me a zero value. I also have an if that gives me the correct value.

How should I write the set analysis for this if expression:

=if(FechaVencimiento<today(),sum(Cargo),0)

This is what i have so far, but giving me always zero values:

=Sum({<FechaVencimiento = {"$(='<' & today())"}>} Cargo)

Thanks!!

[sunny_talwar · Accepted solution]

May be you need to Add date() function with or without format?

=Sum({<FechaVencimiento = {"$(='<' & Date(today()))"}>} Cargo)

or

=Sum({<FechaVencimiento = {"$(='<' & Date(today(), 'FormatHere'))"}>} Cargo)

[cristian_av]

Thanks!!

I've added the date in the set expression with no luck, but adding the date in the load script it worked...

Not sure why.!