4 Replies Latest reply on Apr 24, 2017 5:27 PM by Justin Larson

    Does the dateparse function not work anymore?

    Alex Martino

      Does the dateparse function not work anymore?

       

      I tried this but it says unknown function:

      IF INT(RIGHT([Select Year End Date],4)) = YEAR([First Satisfied Date]) AND [First Satisfied Date] <= DATEADD('month', 1, DATEPARSE("dd/MMM/yyyy", "01"+"/"+LEFT([Select Year End Date],3)+"/"+RIGHT([Select Year End Date],4)))-1

      THEN [Contract ID]

      END