Support archive

How do I get a list of days that have events within a certain channel?

StevenLangbroek 2 Apr 2013 14:19 question, complete

That's pretty much my question :). I want to use it for outputting a select-dropdown, which I'll use to filter an unordered list...

Replies

1. Low 2 Apr 2013 15:05

   There isn't a tag for this at the moment. The Archive tag will give you years or months, the Calendar tag will give you days, but for one month only. Either use that or get creative with the Query module.

2. StevenLangbroek 12 Apr 2013 11:12

   Ok so I've whipped up a query that does this (select DISTINCT start_date from exp_low_events), but because of the way it's stored i can't run format='' parameter on it, any thoughts on how to resolve this?

3. Low 12 Apr 2013 11:18

   You could use UNIX_TIMESTAMP around the date_start to get a timestamp, which should be supporting the format="" param.

4. StevenLangbroek 12 Apr 2013 11:50

   that would look like select DISTINCT UNIX_TIMESTAMP(start_date) from exp_low_events?

5. Low 12 Apr 2013 11:54

   Make that "SELECT DISTINCT UNIX_TIMESTAMP(start_date) AS the_date ... " and use {the_date format=""} inside the tag.

6. StevenLangbroek 12 Apr 2013 11:59

   Thanks! Solved!