Sum hours by pay period
Trying to sum time cards by pay period. I have one table to collect hours worked. Table is "Time Cards". Contains [Date], [Job], [Employee], [Hours]. Have also built a Pay Periods table for 2019 tha...
Forum Discussion
Ok, try this
Make a formual date field called first day of current time period.
The formula will be firstdayofperiod(today(), weeks(2), Date(2018,12,31))
Then have a form rule to fire that says when the pay period date is blank change pay period blank to gr value in the field first day of current time period.
There is a chance that you will need to put that field on the bottom of the form to get that form rule to fire. Also set that checkob on t(e form rule to unchecked, to be sure it fires.
Make a formual date field called first day of current time period.
The formula will be firstdayofperiod(today(), weeks(2), Date(2018,12,31))
Then have a form rule to fire that says when the pay period date is blank change pay period blank to gr value in the field first day of current time period.
There is a chance that you will need to put that field on the bottom of the form to get that form rule to fire. Also set that checkob on t(e form rule to unchecked, to be sure it fires.