{"id":553,"date":"2011-10-10T14:12:20","date_gmt":"2011-10-10T18:12:20","guid":{"rendered":"http:\/\/cfdbplugin.com\/?page_id=553"},"modified":"2014-10-18T19:18:10","modified_gmt":"2014-10-18T23:18:10","slug":"filtering-submit_time","status":"publish","type":"page","link":"https:\/\/cfdbplugin.com\/?page_id=553","title":{"rendered":"Filtering submit_time"},"content":{"rendered":"

As of version 2.2, filtering can be done relative to the current time. This is in response to people wanting to get “all submission in the last week” for example.<\/p>\n

Do this using “submit_time” in the filter. The\u00a0submit_time is a Unix time stamp of when a submission was received. You can use a raw timestamp like:<\/p>\n

[cfdb-table form=\"Contact form\" filter=\"submit_time>1318262984<\/span>\"]<\/pre>\n
But these timestamp values are hard for a human to compute and understand. Now you can use:<\/p>\n
[cfdb-table form=\"Contact form\" filter=\"submit_time>October 10, 2011<\/span>\"]<\/pre>\n
Or you can use a time relative to today<\/strong>.
\nExamples:<\/p>\n
[cfdb-table form=\"Contact form\" filter=\"submit_time>last week<\/span>\"]<\/pre>\n
[cfdb-table form=\"Contact form\" filter=\"submit_time>last Friday<\/span>\"]<\/pre>\n
[cfdb-table form=\"Contact form\" filter=\"submit_time>-1 week 2 days 4 hours 2 seconds<\/span>\"]<\/pre>\n
These kinds of English descriptions<\/strong> of time are parsed based on the PHP strtotime function<\/a>.<\/p>\n
To search between dates<\/strong>, use && (see more on filter<\/a>)<\/p>\n
[cfdb-table form=\"Contact form\" filter=\"submit_time>2013-03-15&&submit_time<2013-03-25<\/span>\"]<\/pre>\n
Don’t Make Easy Mistakes<\/strong><\/p>\n
Do you know what is wrong with this? You think it is going to get values from the last week but it does not.<\/p>\n
[cfdb-table form=\"form1\" filter=\"submit_time>1 week<\/span>\"] WRONG!<\/strong><\/span><\/pre>\n
“1 week” is interpreted as one week from today. “submit_time>1 week” means submissions received one week in the future. \u00a0So of course it shows nothing!<\/div>\n
[cfdb-table form=\"form1\" filter=\"submit_time>-1 week<\/span>\"] RIGHT!<\/strong><\/pre>\n
Use “-” to indicate “now – 1 week in the past”.<\/p>\n
Don’t get Confused About Greater-than and Less-than<\/strong><\/p>\n