4 Replies Latest reply: Sep 5, 2017 1:54 PM by Rob Wunderlich RSS

    Why does the expression date('mm/dd/yyyy')>='mm/dd/yyyy' work independently of the format?

    Julio Andrés Arriaga Rangel

      Hi everyone,

       

      Thank you in advance for your time in answering this question.

       

      How does QV know how to apply a criteria of '>=' to a date string independently of the formats? As these are basically different strings (image 1 and 2), shouldn't they give different results?

       

      P.S. I know date is a formatting function but still the script registers it as a string.

       

      image 1

      Capture1.PNG

       

      Image 2

      Capture2.PNG