3 Replies Latest reply on Jul 28, 2017 6:29 AM by mortenbodaugaard.jrgensen

    How to format a date in c calc

    Hannah Williams

      Hiya

       

      I am trying to create a filter using a boolean, whilst the cacl is valid, it is not picking up any of the data. I tried a number of date formats:

       

      IF [Invoice Date] <= (DATE(30/06/2017)) then 1 ELSE NULL END

      IF [Invoice Date] <= (DATE(30-06-2017)) then 1 ELSE NULL END

      IF [Invoice Date] <= (DATE(2017-06-30)) then 1 ELSE NULL END

       

      Any ideas?

       

       

      Thanks

      Hannah