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’.
![](https://secure.gravatar.com/avatar/de1749a36304d2a53a246b77c45529c9?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)