Set analysis for date does not work

[mtabernad]

Hi community,

I have this table:

I want to calculate the sum of numattacks where id_threat_type = 5 and date = 2020-10-16. The result should be 194, but it shows 0:

I think it could be a date format problem. In the script date variables are like this (D/M/YYYY):

But when date field shows up in a table its format is 'YYYY-M-D' as you. can see in previous captures. I do not know how. to solve it. 

Thank you in advance!

[Anil_Babu_Samineni · Accepted solution]

I can see you've missed {} for date like how you've done for {'5'}?

And this is not recommended rather try this way for date {"$(=Date(MakeDate(2020, 10,16), 'YYYY-MM-DD'))"}