Forums › Forums › Search & Filter Pro › Filtering by Events Manager dates

Tagged: ,

Viewing 9 posts - 1 through 9 (of 9 total)
  • Anonymous
    (Private)  August 9, 2018 at 9:42 am #184906

    Hi,
    I’m using Search & Filter with events in Events Manager. On the Post Meta tab, I am using the event date (_event_start_local) in order to display the events chronologically by the event start date, beginning with today’s date.

    I would also like to enable a search by event start date, using the Post Meta Date selection field. I cannot get it to work at all. Do you have any ideas what I would need to do to get it to function?

    Thanks.

    Trevor
    (Private)  August 9, 2018 at 9:54 am #184907

    It depends what format Events Manager is storing the dates in the database in. For the Date filtering to work in Search and Filter, the dates must be stored in the yyyymmdd format (always eight digits, with zeroes to pad, e.g. today is 20180809.

    You can (quickly) inspect what data is there using our plugin in the Form UI.

    Add a Post Meta to the Form UI. Of the three types tabs, choose ‘Choice’. Select the Meta key for your dates and Under get Options select ‘Manual Entry’. Below that you will now see an option to ‘Browse Values’. A box will appear with all the values stored in the database.

    Anonymous
    (Private)  August 9, 2018 at 10:06 am #184911

    Thanks — The dates are stored in this format:
    2018-03-22 20:00:00

    Could I make a code change so that these dates will be recognized?

    Trevor
    (Private)  August 9, 2018 at 10:57 am #184929

    Sadly not. That is a date and time stamp, which we do not support. I do not know if the events plugin is able to store them in a different format, you may need to ask them.

    Anonymous
    (Private)  August 9, 2018 at 7:22 pm #185016

    I asked them and they said they no longer use a time stamp and that if I use _event_start_date then the date is in 2018-08-09 format (without the time). But if I understand it correctly, the hyphens are the problem?

    Trevor
    (Private)  August 10, 2018 at 9:01 am #185046

    They may be a problem like that yes. Did you try it using that meta key?

    Anonymous
    (Private)  August 10, 2018 at 9:03 am #185048

    Yes I did but it didn’t work unfortunately.

    Trevor
    (Private)  August 10, 2018 at 9:08 am #185052
    This reply has been marked as private.
    Trevor
    (Private)  August 10, 2018 at 9:48 am #185062

    Great to speak with you Jean. It looks like the only solutions are to either persuade the Events Manager author to add an option for the save format of the dates, or create a dummy date field and copy the date and alter the format and hook in to the WordPress save_post hook.

  • Author
    Posts
Viewing 9 posts - 1 through 9 (of 9 total)