Post reply

DateAdd DateInterval Confusing Puzzle

  • October 21, 2009 at 2:39 pm

    #385623

    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

    #1069131

    Actually I think it should be >=

  • October 21, 2009 at 3:23 pm

    #1069154

    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
    Problems are opportunities brilliantly disguised as insurmountable obstacles.

    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