0 Replies Latest reply: Nov 9, 2015 2:56 AM by Teresa Hooper RSS

    Filtering between 2 dates

    Teresa Hooper

      I have employees who were paid within the 2015 financial year

       

      They then terminated in the 2016 financial year

       

      I want to count the terminated employees that occurred in the 2015 financial year and not those that have a termination date in the 2016 financial year

       

      Joe Bloggs    Terminated 30 June 2015

      Jane Mary     Terminated 15 June 2015

      Tess Jones    Terminated 16 July 2015

      John Jones     Terminated 15 August 2015

       

      The calendars are set for actual pay dates (not termination dates) being within the fiscal year  - although that information is in the database.

       

      I only want to count 2 for the 2015 year

       

      So how to I ask QS to only choose employees who were terminated in 2015 -   whilst using filters for the fiscal years.

       

      At the moment it is choosing 4 -  as the four employees were paid during the 2015 but only 2 terminated during this year

       

      I don't want to hardcode in the IF Statement - start and finish dates

       

      Hope this makes sense