AnsweredAssumed Answered

Chose a specific active row in a table with start and end dates

Question asked by mmainville on Apr 12, 2018
Latest reply on Apr 12, 2018 by philmodjunk


I have a small project management solution and to create a cost report for the projets I need to be able to get the actif payrate at the moment the work was performed. I have a table with the employee ID, payrate and effectif start and end dates for the payrate. On the timesheet details, I have the employee ID and the worked date. In SQL this would be a simple select query with Select payrate from Payrates join Timesheetdetails on employeeid where dateworked >= EffectifStartDate and dateworked <= EffectifEndDate

 

How do I do this in FileMaker?

Outcomes