How to show date rows equals current date?

@jelz2018,

I found the problem. If you used the bold code then I forgot to add the comma at the end of the first case when condition. I added it (it's the red comma). You should be good to go now.

Please added a comma at the end of 1st_date. That will fix your error.