number of employee who's experience is 2 year or less !

[Anonymous]

Hello everyone ,

how can I calculate the number of employee who's experience is 2 year or less ??

I should subtract 2 year from today ..

I tried to write many expression but I don't find the correct result !!

------------------------------------------------------------------------

count(

      ${

        <

        //addmonths(date(original_date_of_hire),-24)

        //original_date_of_hire = (max(Year-2))

        //= Month(AddMonths(original_date_of_hire,-24))

        //Date = P({<Year={$(=max(Year)-2)}>}original_date_of_hire)

        //Year= {$(=original_date_of_hire(Year-2))}

        //Year = {$(=max(original_date_of_hire)-2)}

        //if (original_date_of_hire - today()>=2 ,1,0)

        //=original_date_of_hire(makedate(today())-720)

        //original_date_of_hire = date(AddMonths(today(),-24))

        //date={"$(=date(max(date)-100))"}

        //original_date_of_hire = AddMonths( Today(), -24 )

        >

      }

distinct Employee_Assignments.person_id)

------------------------------------------------------------------------------

*((( original_date_of_hire  ))) this is start date of employee

please help me, How can I solve it ?

[Lisa_P]

Hi Bayan,

Try this ....

count(

      {$

        <

        original_date_of_hire =   // Start date

          { ">                              // >  greater than, " " search

               $(=                         // $(=     )  Dollar sign expansion to evaluate an expression within set analysis

               Date(AddMonths( Max(Today()), -24))     //  Date format,  Add -24 months to Today

               )

               "}

        >

      }

distinct Employee_Assignments.person_id)