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

Date - 10 days

I working on a forecast report where I am pulling a date from a table and the
client wants to grab the date and subtract 10 days from the date.
I tried the expression =date.value-10, but this obviously didn't work.The expression is as follows:
=DateAdd("d",-10,Fields!Date.value)
"Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> wrote in message
news:27A2F586-962D-4F90-9029-699C4041C0C4@.microsoft.com...
>I working on a forecast report where I am pulling a date from a table and
>the
> client wants to grab the date and subtract 10 days from the date.
> I tried the expression =date.value-10, but this obviously didn't work.