Improve Entries SQL
I just purchased a paid version of the Smart Form plugin (39.00) and it appears to not save values to the database. When I go to look at the entries on my test forms there’s nothing there. It was sending emails however.
I went in and changed the date range to start at 1/1/2019 and end tomorrow (1/28/2019) and it returned values. This indicates there is an issue with the SQL you are writing. Please retest your sql. I only entered data today and so I set the date range to start and end on this day. I should get results back only for this day. What happens if in 2 weeks I want only the data entered for one day? Setting a wider date range is not an acceptable work around.
My first hunch is that you will need to add a time stamp if it is a single day so your where would be something like: ‘where submitDate > ’01/29/2019 00:00:00′ AND submitDate > ’01/30/2019 00:00:00’.