Search Range:edit_date problem
How to search a entry , edit_date using range?
I try following the example, but it didn't filter out the results
I am using this as the code, very similar to the example
{exp:query sql="SELECT DISTINCT DATE_FORMAT(edit_date, '%Y-%m-01') date_from,
DATE_FORMAT(edit_date, '%Y-%m-01') + INTERVAL 1 MONTH AS date_to,
DATE_FORMAT(edit_date, '%M %Y') AS month_label
FROM exp_channel_titles
WHERE edit_date != ''
ORDER BY date_from DESC
LIMIT 24"
}
{month_label}
{/exp:query}
With this as the only search option, it returns me everything..
Can you please advice.
Thanks!
Replies
Low 3 May 2014 15:35
What version of Low Search are you running?
SamuelKwong 4 May 2014 10:31
3.1.2
Low 4 May 2014 10:55
Support for standard fields like entry_date was added to version 3.1.4, so I recommend upgrading.