Title: Cant filter by submit_time
Last modified: February 21, 2020

---

# Cant filter by submit_time

 *  [paulasd58](https://wordpress.org/support/users/paulasd58/)
 * (@paulasd58)
 * [6 years, 2 months ago](https://wordpress.org/support/topic/cant-filter-by-submit_time/)
 * Hello,
 * I am using shortcode_html to display the form details. One of my tables is to
   show “Done” entries, but I don’t want it to show anything older than 3 months.
   In the shortcode, I have ‘filter=”submit_time>-3 months&&_ctc_status=Done”‘ if
   I use ‘filter=”_ctc_status=Done”‘ it will show the done entries. If I use ‘filter
   =”submit_time>-3 month”‘ it only returns the header of my table.
 * I have validated in the shortcode creator “Valid: ‘-3 months’ = 1574360967 = 
   11-21-2019 18:29:27”. So in my PHPMyAdmin, I entered the query. “SELECT * FROM`
   contactic_submits` WHERE submit_time > 1574360967 AND field_value = ‘Done'” and
   it returns the entries that are done and have a submit_time > 1574360967.
 * However, it won’t do the same from the shortcode. Just gives an empty table. 
   Here is beginning of my HTML shortcode
 * [cfdb-html form=”Contact Form” filter=”submit_time>-3 months&&_ctc_status=Done”]
 * Again, if I put filter=”_ctc_status=Done” it returns Done entries, however, if
   I put filter=”submit_time>-3 months&&_ctc_status=Done” it displays nothing but
   an empty table. Although, I am positive there are entries with a submit_time 
   greater than 3 months ago that are marked done.
 * I have even tried [cfdb-html form=”Contact Form” filter=”submit_time>1574360967&&
   _ctc_status=Done”] and it still will not return the entries
    -  This topic was modified 6 years, 2 months ago by [paulasd58](https://wordpress.org/support/users/paulasd58/).
    -  This topic was modified 6 years, 2 months ago by [paulasd58](https://wordpress.org/support/users/paulasd58/).

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Thread Starter [paulasd58](https://wordpress.org/support/users/paulasd58/)
 * (@paulasd58)
 * [6 years, 2 months ago](https://wordpress.org/support/topic/cant-filter-by-submit_time/#post-12466439)
 * Extra info, I am using the cfdb plugin version by Contactic. My WordPress version
   is 5.3.2, PHPMyAdmin version is 4.8.3.
 * I have tried every variation of the submit_time filter that is provided in the
   documentation, I cannot get any filters by submit_time. I even took a submit_time
   directly out of the database and put it in the filter as submit_time= and it 
   wont return that ticket either.
 *  Thread Starter [paulasd58](https://wordpress.org/support/users/paulasd58/)
 * (@paulasd58)
 * [6 years, 2 months ago](https://wordpress.org/support/topic/cant-filter-by-submit_time/#post-12475205)
 * I have now completely removed the contactic plugin and downloaded mdsimpon’s 
   code from github and added it to my wordpress. Everything still works close to
   the same, however, I am still not able to filter by the submit_time. Still just
   returns an empty table through HTML shortcode.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Cant filter by submit_time’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/contact-form-7-to-database-extension_ffffff.
   svg)
 * [Contact Form DB](https://wordpress.org/plugins/contact-form-7-to-database-extension/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/contact-form-7-to-database-extension/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/)
 * [Active Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/reviews/)

## Tags

 * [html](https://wordpress.org/support/topic-tag/html/)
 * [shortcode](https://wordpress.org/support/topic-tag/shortcode/)
 * [strtotime](https://wordpress.org/support/topic-tag/strtotime/)
 * [submit_time](https://wordpress.org/support/topic-tag/submit_time/)
 * [time format](https://wordpress.org/support/topic-tag/time-format/)

 * 2 replies
 * 1 participant
 * Last reply from: [paulasd58](https://wordpress.org/support/users/paulasd58/)
 * Last activity: [6 years, 2 months ago](https://wordpress.org/support/topic/cant-filter-by-submit_time/#post-12475205)
 * Status: not resolved