Problem with Set Analysis and Date

[btrompetter]

Hello,

I want to filter a formular with set analysis and set a selected day but I don't know why it didn't work.

Here is the formular:

count( DISTINCT {$<
$(vLFLFlag) = { $(=vTotalLFLFilter) },
Jahr = { $(vSelectedYear) },
DATUM = { $(vCurDate) }
>} AD_ID_COUNT)

If I set DATUM = { '05.01.2010' } it works, but this is the same as the variable.

Thanks for help.

Bastian

[#2 · Accepted solution]

Hello,

Try this :

count( DISTINCT {$<
$(vLFLFlag) = { '$(=vTotalLFLFilter)' },
Jahr = { '$(=vSelectedYear)' },
DATUM = { '$(=vCurDate)' }
>} AD_ID_COUNT)

Philippe

[btrompetter]

Thanks for the Tip it works.