Hi all
I have a base for managing casual employees’ hours worked. Employees submit hours via a form and payroll uses the entries to pay wages.
Payroll would like to see only the records for the relevant payroll period: 16 May - 19 May and every two w...
@W_Vann_Hall, your solution worked beautifully! Thank you.
I was missing that fixed date as a signpost that could be used to calculate other date periods. Good idea to use Unix time.
Hi
The current payroll period is Wednesday 16 May to Tuesday 29 May 2018.
The payroll period is every two week period thereafter: Wednesday 30 May to Tuesday 12 June; Wednesday 13 June to Tuesday 26 June 2018 etc.
Does that make more sense?
