I’m using a Timesheets table to record employee timesheets.
I’m then using an Employees table to rollup the ‘Time Worked’ durations.
I only want to see the ‘Time Worked’ for today.
I have my rollup conditions set as follows: “only show linked records from the Timesheets table that meet certain conditions: Date is today”
However, I’m in Sydney Australia which is +10 hours GMT.
I don’t see any way of offsetting this time (as it’s only a filter within a rollup field). How can I make the rollup filter ‘today’ line-up with Sydney’s ‘today’?