CURRENT DATE Issue
I have an issue with the CURDATE() function. I have the following beast mode:
`Closing Date` < CURDATE()
I use this beast mode to not sure the incomplete data from the current day (so I filter on Current).
However, the data for the previous day doesn't update until 11am. Our timezone for the company is correct (Melbourne, Australia) but instead of updating at the right time at the beginning of the day for the previous day, it waits until 11am. I know this is the issue as by removing this, the data for the previous day appears.
Any help would be appreciated.