5 Replies Latest reply on May 1, 2018 1:43 PM by Brian Adams

    Identify max month

    Brian Adams

      I'm trying to identify the max month/year for variable Encounter_Date using formula


      DATETRUNC('month',[Encounter_Date]) = DATETRUNC('month', MAX([Encouter_Date])


      but it tells me I can't mix aggregate and non-aggregate arguments.


      Anyone have a better way?