I have a news section with a date/time field called event date. This field is only completed if the news article relates to an event on a specific date.

I need to pull out a list of articles which either have no event date (ie they don't expire) or which have event date that is today or later.

I can filter results by later than today, but that excludes entries for which no event date is set.

Can anyone suggest how I could go about this please?

Maybe you could use two data-sources and then merge them back using a union-datasource?

That's the first thing that comes to mind; not too sure you could use a single datasource to get both data-sets.

Sounds like a good idea. Will try, thanks.

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