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

    Filtering between 2 dates

      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