IF condition with date

[zied_ahmed1]

Hello,

in a pivot table I have a date like 01/01/2017

i need an expression like this

  if (Dimensionality()=1,' ',

(if (Dimensionality()=2 and date>'01/06/2017',

'Hello'

)))

But it doesn't work (when i delete the condition of date it display hello...

regards

[sunny_talwar]

May be use Makedate() function

if (Dimensionality()=1,' ',

(if (Dimensionality()=2 and date>MakeDate(2017, 6, 1),

'Hello'

)))

[zied_ahmed1]

Thank you sunny but it doesn't work

[sunny_talwar]

is date a true date field?

[zied_ahmed1]

yes yes it's like 01/01/2017

[sunny_talwar]

Then no idea

[marcohadiyanto]

Hi Zied,

May i know your dimensions?

I tried i can do with your expression when i put my date as my second dimensions.

You should try that.

But why you want to filter the date?

Regards

Marco