Filter issue with report

Hi all

Yesterday I created a report from a source sheet, which all works fine for me. I set viewing rights for the report and source sheet for a colleague and shared the report with them.

Today when I run the report it correctly displays only the specific data which has a "start day" of "today", as per the filters.

When my colleague runs the same report, drawing information from the same sheet at the same time as me, it displays data from yesterday.

Both of our reports update when we change the source sheet information, so we know that they are both returning current information, however when we both run the same report at the same time, it seems to be filtering and returning different lines from the source sheet, based on some issue with the dates??

Can anyone help with this?

Best Answer