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.