I am trying to write an expression that says

iif (field.receipt date is < currentdate by 30 days, then grab field.cost,
if not then blank " ")

Basically, I am trying to write a report for aging buckets.

Thanks,

On Jun 14, 3:07 pm, Ryan Mcbee <RyanMc...@discussions.microsoft.com>
[quoted text, click to view]


Something like this should work:
=iif(Fields!ReceiptDate.Value < Dateadd("d", -30, Now()), Fields!
Cost.Value, Nothing)

Regards,

Enrique Martinez
Sr. Software Consultant