Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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