Showing Expired Entries Only. Not working

Question

I want to show previous concerts (past concerts) under a special tab. I only want to show past concerts, not current or upcoming concerts that is under a different tab. I tried the following code. Using EE 2.x

 {exp:channel:entries channel="concerts" sort="desc" limit="20" show_expired="yes" }

  {if expiration_date < current_time}

  {concert-info}

  {/if}

  {/exp:channel:entries}

This does not work it shows both upcoming concerts and past concerts. I double checked and the past concerts have an expired dates and they have expired.

Answer 1

You can use condition like a below:

{if expiration_date < current_time AND expiration_date!=""}

Alternatively,you can use below query to get the records:

SELECT
    t.entry_id,
    t.title,
    t.url_title,
    d.field_id_XX AS your_custom_field
FROM
    exp_channels AS c NATURAL JOIN
    exp_channel_titles AS t NATURAL JOIN
    exp_channel_data AS d
WHERE
    c.channel_id = your_channel_id AND
    t.expiration_date != 0 AND
    t.expiration_date < UNIX_TIMESTAMP()

Answer 2

Expanding on my original comment, it turns out you can use shorthand as well as long format.

{exp:channel:entries
  channel= "mychannel"
  start_on = "-12 months"
  stop_before= "yesterday"
  show_expired = "yes"
  ...
}

This will look back 12 mths until yesterday.