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?

       

      Cheers

      Carl