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?

       

      Thanks,

       

      Brian