I can't seem to figure out why this started happening... It didn't start until recently. I have a table that's connected to a dataset to simply put what's in the dataset into the table (nothing was coded).
Now, when the page loads, it shows the correct dates as I see them in the dataset. A couple seconds later, one day is subtracted from the dates in the table.
If I refresh the page, same thing... Correct dates, and in a couple seconds they change subtracting a day.
I tried turning on "Fetch after the page loads" in the dataset settings under Performance. This only made it so I didn't see the date dynamically change, but still showed the date minus a day.
Here's a video demonstrating the behavior, if it helps (sorry, it's not very 'Hollywood', but should get the point across... Also, excuse the blurred columns, etc. - I didn't want to post any sensitive information, just what's relevant):
Can anyone explain this, or have a workaround?
Thank you!!
you need to subtract one day from today's date. Use CURDATE() to get today's date. In MySQL, you can subtract any date interval using the DATE_SUB() function. Here, since you need to subtract one day, you use DATE_SUB(CURDATE(), INTERVAL 1 DAY) to get yesterday's date. Clover Dashboard