October 21, 2009 at 2:39 pm
75 days in the future should say "FIRST NOTICE" and less than 75 days should say "FINAL NOTICE"
IIf(DateAdd(DateInterval.Day,75,Today)<=Fields!invoicedate.Value,"FIRST","FINAL")
October 21, 2009 at 2:41 pm
Actually I think it should be >=
October 21, 2009 at 3:23 pm
When I run into these kinds of issues, I write it out using psuedo-code then convert it to the function:
If invoice date is greater than 75 days from today, then 'FIRST' else 'FINAL'
Convert that to:
=IIF(Fields!InvoiceDate.Value >= DateAdd(DateInterval.Day, 75, Today()), "FIRST", "FINAL") & " NOTICE"
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply