Paginated report date picker query error

[Anonymous]

I am trying to write this date picker query in  report Builder but keep getting an error

=IIf(NOT IsNothing(Fields!ACT_START_DATE.Value), AND (Fields!BL_START_DATE.Value Is Nothing),DateAdd("d",3,Today())) does anyone know what i am missing ?

here is the error message

The Value expression for the field 'Test' contains an error: [BC30201] Expression expected.

[v-kkf-msft · Accepted solution]

Hi @Anonymous ,

Please try the formula.

= IIf( NOT IsNothing(Fields!ACT_START_DATE.Value) AND (Fields!BL_START_DATE.Value Is Nothing), DateAdd("d",3,Today()))

Best Regards,
Winniz