With the following SQL code you can check if the customer has visited the store this day.

It should be installed using the instructions here.