5 Replies Latest reply on May 1, 2018 12:36 PM by Joe Oppelt

    Using If then statement to filter with multiple dates

    Tyler Smith

      Hello, I am trying to create a calculated field and am having some trouble. I want to get the results of an If then statement where it compares dates and only shows dates where one of the two fields is after the other one. That may sound confusing so here is where I'm at...

       

      If STR([Datereceived]) > str([Finalreportsentdate])

      then STR([Datereceived])

      ELSE ""

      END

       

      Basically if datereceived is after finalreportsentdate then I want the datereceived to be shown, if not there should be a blank field

      right now the result only works for specific months.

      Thanks in advance for any help I get!