set analysis date comparator: HELP!

[#1]

Hi all,

I post my document:

why

DISPOSIZIONI.DatOpe

={"<=$(Date(DFineStat,'DD/MM/YYYY'))"}

doesn't work?

Anyone has a good idea?

Thanks a lot!

[#2]

Hi Roberta,

it seems that you missed DISTINCT in your expression.

Rainer

[#3]

Hi Rainer!

I think it's not a problem : using distinct reduce the count result, but set analysis expression still does not work....

Thanks anyway!

[#4]

Roberta,

don´t give up ...

Hope the result is correct now.

Rainer

[#5]

Attachment was missing ...

[#6]

Here are the expression

count({$<[DISPOSIZIONI.DISP_COD_CAU]={'SO'}, [DISPOSIZIONI.DatOpe]={"<=$(=addmonths(DFineStat,0))"}>} Distinct [DISPOSIZIONI.DISP_NUM_OPE])

[#7 · Accepted solution]

Here are the expression

count({$<[DISPOSIZIONI.DISP_COD_CAU]={'SO'}, [DISPOSIZIONI.DatOpe]={"<=$(=addmonths(DFineStat,0))"}>} Distinct [DISPOSIZIONI.DISP_NUM_OPE])

[#8]

the attachement.

[#9]

Thanks Rainer ,it's working now!

But I don't understand why needs to use addMonths....Can you explain me the reason?

Thanks a lot!

Bye

Roberta

[#10]

Good morning Roberta,

the reason to use AddMonth was: formatting using the date function did not work in the way we used it.

I will have look in an older application. So far I remember there is a SetAnalysis expression in it using TimeStamp format.

I´ll let you know if I have something figured out.

Rainer