Date Expression

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,
RyanOn Jun 14, 3:07 pm, Ryan Mcbee <RyanMc...@.discussions.microsoft.com>
wrote:
> 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,
> Ryan
Something like this should work:
=iif(Fields!ReceiptDate.Value < Dateadd("d", -30, Now()), Fields!
Cost.Value, Nothing)
Regards,
Enrique Martinez
Sr. Software Consultant