Date in set analysis doesn't work

[Anonymous]

Hi

I can't seem figure out why below expression doesn't work?

Sum({<CUSTOMER -= {'IA','KA','BA'},EFlag = {1}, TILLÆG = {0}, Promostep = {0}, Enet = {100,149,299}, Created = {">=$('05-05-2017')"} >}   Enet_calc)

It seems like the expression simply ignore the date limitations, and just present the full value, as if the date limitation wasn't implemented.

Below is the dimension I'm trying to use.

I guess it might be something with date format or something. But I tried several alternatives found on the internet, and nothing seems to fix it.

I hope someone can help.

Regards

Stefam

[lironbaram · Accepted solution]

hi

maybe something like this

Sum({<CUSTOMER -= {'IA','KA','BA'},EFlag = {1}, TILLÆG = {0}, Promostep = {0}, Enet = {100,149,299}, Created = {">=$(=date('05-05-2017','dd-MM-yyyy'))"} >}   Enet_calc)

[swuehl]

Why are you using a dollar sign expansion on a constant value?

Try

Created = {">='05-05-2017'"}

If DD-MM-YYYY is your default date format.

Or maybe

Created = {">=42860"}

[Anonymous]

This worked.

However, I've tried this before. Maybe I've forgotten parentheses or something.

But thanks so much for the quick respons!

Regards

Stefan