How to show date rows equals current date?

@jelz2018,

What we are doing is putting together a string that should be converted to a date value in order for it to be compared to the current date value.

Basically what select DATE(concat(year,'-',month,'-',multiple)) should give you is (1st record)... '2018-07-30'

The error message that you received is stating that the year field does not exist. Is that right? If so, what is the actual field name?

The day column (multiple) is a little bit tricky. We will need to put a condition in place to handle how it is used in the concat function.