Hi Dani, Thanks for the link to the article. Unfortunately it is doesn't help solve my problem. The datasets are updating and as I wrote above the timezones are fine. The problem is the beast mode calculation as I mentioned in the start. If I remove it everything is fine. Does anyone know why the CURDATE() function is not…

Hi Scott, Thanks for the proposed solution. However, what I would like is not for the information to be updated at 11am but in the morning on the day of when it should update. I.e. at the moment the data for the previous day doesn't update until 11am. I would like it to update at 00:00. I think the solution you have…

Thanks for the idea user07995! I'll implement it and see how I go.

Hi Valiant, Any update on the issue I am facing? Can anyone help out with this issue? Thanks!

Hi Valiant, Thanks for that but the problem is that I want to do something like Financial Year to Date. If I were to follow your suggestion, I would have to manually update the date each day. I would like something that does it automatically but with a customer year range. There exists a year to date, month to date, etc.…