4 Replies Latest reply: Sep 14, 2017 4:44 AM by kushal chawda RSS

    Finding the flag value of a min(date) in script

    Tom Neal

      Hi all,

       

      I'm trying to write an if statement which goes something like this:

       

      If(Min(Date) and Flag = 'DE-ACTIVE', ApplyMap('SubmitDate', RefNo)) as Date

       

      I know this isn't correct but I'm not sure how to fix it to make it correct.

       

      I'm looking for the minimum date and want to see if the flag on that date is 'De-Active'.  If it is then do the apply map.

       

      Thanks,

      Tom