I’m trying to filter datasource by date using both earlier than and default value:

earlier than {$url-date:2100-01-01}

I can’t get it to work. If date in url is not provided default value is not used and I see <error>No records found.</error> in the xml source. If date is provided everything is ok. Is this a bug or I am doing something wrong?

this happens in symphony 2.0.8RC2 and after updating to 2.1.1

[edit 2] I’ve changed filter rule to:

earlier than {$url-date:2038-01-01}

and now it’s working.

This is related to PHP’s date and time handling. From

5.1.0: The valid range of a timestamp is typically from Fri, 13 Dec 1901 20:45:54 GMT to Tue, 19 Jan 2038 03:14:07 GMT. (These are the dates that correspond to the minimum and maximum values for a 32-bit signed integer). However, before PHP 5.1.0 this range was limited from 01-01-1970 to 19-01-2038 on some systems (e.g. Windows).

Create an account or sign in to comment.

Symphony • Open Source XSLT CMS

Server Requirements

  • PHP 5.3-5.6 or 7.0-7.3
  • PHP's LibXML module, with the XSLT extension enabled (--with-xsl)
  • MySQL 5.5 or above
  • An Apache or Litespeed webserver
  • Apache's mod_rewrite module or equivalent

Compatible Hosts

Sign in

Login details