Set Analysis Issue

[eduardo_dimperio]

Hi,

I need to count all [DATA_LIMITE] that >= Today(), but my field are not in Date Format, so i tried with a more simple equacition (just equal), with "If "condition.

If (FLOOR([DATA_LIMITE])=FLOOR(TODAY()), TRUE,FALSE)

With this i got 'true' where need to be 'true', so i tried the same logic to set analysis and did not work like i expected.

I tried use that

COUNT(${<FLOOR(DATA_LIMITE)={"$(=FLOOR(TODAY()))"}>}DISTINCT OID_SYSTEM)

Thank you

[stigchel]

If you want to limit the results to today and no future dates then

Count({<DATA_LIMITE={">=$(=FLOOR(TODAY()))<$(=FLOOR(TODAY()+1))"}>} DISTINCT OID_SYSTEM)

[zebhashmi · Accepted solution]

you are right but it will be inside of curly braces

[eduardo_dimperio]

I change my code to DATE_LIMITE be in Date Format, but still not working

COUNT(${<DATA_LIMITE = {"$(=TODAY())"}>} DISTINCT OID_SYSTEM)

[eduardo_dimperio]

hahaha thats right! You solve!

Thank you.

COUNT({$<DATA_LIMITE = {"$(=TODAY())"}>} DISTINCT OID_SYSTEM)

[zebhashmi]

Great Thank you, it was nice to talk to you!