• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Only show future dates in directory list

Only show future dates in directory list 10 years 8 months ago #28889

Hi,

I only want to show future dates (from a field in submissions) in a directory list, not the past dates.

So I tried to add several code scripts to the custom scripts section in Directory manager. However, nothing happens. Even no helpfull errors.

This I got now:
$submissionId = JRequest::getInt('id');
$db = JFactory::getDbo();
$today = date("d.m.Y");
$db->setQuery("SELECT * FROM #__rsform_submission_values
WHERE EndDate >= $today ");
$db->execute();

Someone got some hints to get this working?

Thanks.
Last Edit: 10 years 8 months ago by jeroen.van.krimpen.
The administrator has disabled public write access.

Only show future dates in directory list 10 years 4 months ago #30437

  • peter52
  • peter52's Avatar
  • OFFLINE
  • Senior Boarder
  • Posts: 65
  • Thank you received: 3
I need this aswell - can somebody please help ?
The administrator has disabled public write access.

Only show future dates in directory list 10 years 3 months ago #30668

  • peter52
  • peter52's Avatar
  • OFFLINE
  • Senior Boarder
  • Posts: 65
  • Thank you received: 3
Nolting?
The administrator has disabled public write access.

Only show future dates in directory list 10 years 3 months ago #30674

  • peter52
  • peter52's Avatar
  • OFFLINE
  • Senior Boarder
  • Posts: 65
  • Thank you received: 3
Hello Jeroen !

Have You ever found a solution for that?
I need it badly, as entries are growing and most of them are in the past
Thank You for any help !
Peter
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!