8 Replies Latest reply: Dec 7, 2017 2:51 AM by omar bensalem RSS

    How can I validate a date inside a Load?

    Bernardo Araujo

      So, I am trying to figure out how to do an auxiliary table showing the ServiceID and the name of the Representative based on the region and the time frame that each representative worked.

       

      I've tried the following:

      Relation:

      Load

      ServiceID,

      Date,

      Region

      Resident Services;

       

      Join

      Load

      Region,

      Representative

      Resident RepHist

      Where

      Start<Date and

      not(End<Date);

       

      Here is an example of my structure:

      Table: RepHist

      t1.PNG

      Table: Services

      t2.PNG

       

      Thanks in advance.