Set analysis -- compare two dates

[#1]

Hi!!
It's possible compare two dates in set analysis?

i would like to something like this:

Sum({< Data_Plan = {"<=$(Data_Ven)"} >} Valor)

I know it's possible do that using the (IF) condition, but it's possible with set analysis?

Best regards

Diogo Pereira

[Miguel_Angel_Baeyens]

Hi Diogo,

Both field Data_Plan and variable Data_Ven must have the same format. You can anyway try

Sum({< Data_Plan = {"<=$(=Date(Data_Ven))"} >} Valor)

but that will only work if Date(Data_Ven) has the same exact format as Data_Plan.

Hope that helps.

Miguel

[IAMDV]

Hi,

Please make sure that both the fields share the same date format. If not, you will have trouble matching the dates. I would recommend you to convert the field in Number format for easy matching. Because underlying dates in QV are just numbers. Probably you can use Dual() function to keep both the formats.

Cheers,

DV