What i did wrong ?

[Maciej29]

Hi , could you please support me, what is wrong with my expression ?

=if([Date Modified]={">$(='1/1/2019')<=$(=today())"},[Date Finished],'')

Appreciate your help!

[sunny_talwar · Accepted solution]

Is this used as a calculated dimension? Try this

=If([Date Modified] > MakeDate(2019) and [Date Modified] <= Today(), [Date Finished])

[Maciej29]

Thank you Sunny ! If i would like to use this condition for KPI indicator, how should it look if want sum Net Value with more than one condition (including mentioned period of time (2019-today())?   Sum(if(match ?