I found this while working with a colleague and was faced with a sticky situation at work. I have this table in my database. However, I would like to send the data from the period date a day late. For example, I would like an email reporting Monday data on a Tuesday morning. So Friday reports Thursday data.
Now, here’s the problem. I would like to report Friday data, not Sunday data on Monday.
How did we solve it? Let's find out
Read more...