0

I'm trying to create a template that will display a list of entries that have been added or edited since a particular date. The date would be passed as a UNIX timestamp in the URL like so;

mydomain.tld/entries_since/1391212800

I have tried doing something like this but I believe this is not working due to the edit_date in ExpressionEngine not being stored as a UNIX timestamp;

{exp:channel:entries
    channel="items"
    status="open"
    search:edit_date=">={segment_2}"
}
<pre>Title: {title}, URL: {url_title}, Edit Date: {edit_date format="{DATE_W3C}"}</pre>
{/exp:channel:entries}

Wondered if anyone could help? :)

2

I believe, your options are:

  • to change the format of date you're using on the segment_2, which isn't a good idea because EllisLab can some day finally normalize all date fields;
  • to reformat the date to match the way its used on edit_date database column;

To change the date format, I suggest you the Low Nice Date plugin:

{exp:low_nice_date date="{segment_2}" format="%Y%m%d%H%i%s"}
2
  • Hey Robson, thanks for the link to the Low Nice Date plugin. Looks like it may not be possible to get the entries edited since a date through the standard channel entries tag. Perhaps need to write a query instead. Jun 24 '14 at 10:31
  • @doubleplusgood, really? Even using parse="inward" on exp:channel:entries?
    – Sobral
    Jun 24 '14 at 13:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.