6 Replies Latest reply on May 10, 2018 5:12 AM by Ritesh Bisht

    Conditional Date Based on another Date field

    Tyler Smith

      I am having trouble figuring out how to code this calculated field and would love to get some advice if anyone here can figure this out.

      So here's whats going on. I have datereceived filtered so it only shows if it is after finalreprtsentdate and finalreportsentdate is not blank. I have excluded all null values as well

       

      What I am trying to do is edit finalreportsentdate so that it picks the most recent date out of all possible dates (there are multiple projects with different report dates), I have tried putting the max command on finalreportsentdate but that causes an error

       

      if [Datereceived]>[Finalreportsentdate]

      and [Finalreportsentdate]<>date("")

      then [Datereceived]

      end

       

      Thankyou in advance to anyone who can help