Loading...
 
Skip to main content

Features / Usability


Filtering articles by date range

I am trying to filter articles after a certain date. The values in the db tiki_articles.publishDate are similar to 1140828060

How can I filter against these values?

The code that I have so far is.
{section name=ix loop=$listpages} {if $listpagesix.disp_article eq 'y' and ($listpagesix.type eq 'Workshop' or $listpagesix.type eq 'Retreat')and $listpagesix.publishDate)>

Feel that information about working with these time formats must be somewhere in the documentation but haven't found it.

All these dates are timestamp. See the php documentation for more details
Don't forget you have smarty modifiers to transform these dates to something redeable
{$date|tiki_short_datetime}
Good luck
sylvie