Comparing field and variable in set analysis

[Anonymous]

Dear Colleagues,

I have to calculate all the production orders which release date (field "DATA_EMISSAO_OS") has happened before a set date (variable called "vData_OS").

For that, I am using the following set analysis formula, but its not working.

Count(DISTINCT {<[DATA_EMISSAO_OS] = {"<=$(vData_OS)"}>}  ID)

Is there any of you who can help me out with that issue?

Thanks!

[vinieme12]

Does the date format of Field [DATA_EMISSAO_OS] match the date format of your variable??

Read the below thread

Dates in Set Analysis