4 Replies Latest reply: Sep 12, 2016 8:13 PM by Carl Blunck RSS

    Return employee contracts within a month

    Carl Blunck

      Hi folks,


      I have a table of employee contracts that all have a start and end date and I want to show these in a straight table based on a MonthYear selection.


      Created a master table that is linked through the start date field so at present, when I select a MonthYear, the straight table shows records which have a start date in that month.


      But what I want the table to show is all of the contracts that exist in this month.  Thought this would be done through a calculated condition as follows:


      If(MonthStart([Start Date])<=MonthYear and MonthStart([End Date])>=MonthYear)


      But I am getting an error in expression return for the last ')' and I can't work out why?!


      Is this even the right way to go about this?