2 Replies Latest reply on Jul 19, 2018 5:33 AM by Bryce Larsen

    Checking conditions on Year , facing cannot mix aggregate and non--aggregate error

    Pavithra s

      Hi All,


      I have a date field in the format "yyyy-mm-dd"  and am extracting year(date) and checking the following condition:


      if Year(date) = Year(Today)


      But I am getting the error " Cannot mix aggregate and non -aggregate values in comparisons".


      It would be great if you would let me know if I am missing something in resolving this error.


      Thanks in advance.