2 Replies Latest reply: Sep 27, 2012 5:29 AM by Helen Pippard RSS

    Invalid Expression:  Date Field in resident load

    Helen Pippard

      Hello

       

      Could someone kindly tell me why I am getting an invalid expression by adding in the MonthYear into a resident table?

       

      I get this error every time I add in a date field into my resident table

       

       

       

      Invalid expression

      ED_Patients1:

      LOAD

      Median([Total Wait])/1440 as Total_Wait_Median,

      Fractile([Total Wait],0.95)/1440 as Total_Wait_Fractile,

      Median([Triage])/1440 as Triaged,

      MonthYear

      RESIDENT ED_Patients

       

      Does anyone have any ideas?

       

      Thanks

      Helen