Forums › Forums › Search & Filter Pro › search form with post POST META (date and time)

Viewing 6 posts - 1 through 6 (of 6 total)
  • Anonymous
    (Private)  July 31, 2014 at 12:42 pm #3077

    Please! Help me ASAP!

    Ross Moderator
    (Private)  July 31, 2014 at 1:37 pm #3079

    Hey gianfranco – what format is the date stored in the database? The date must be stored as either a timestamp, or YYYYMMDD – these are the only formats for saving in the database that are supported currently.

    Anonymous
    (Private)  July 31, 2014 at 2:53 pm #3088

    The data was stored as YYYY-MM-DD, so it didn’t work with Search & Filter Pro.
    Now I’m trying to store my custom data field without “-“, and it seem to work now.

    Thank you for your help!

    Ross Moderator
    (Private)  July 31, 2014 at 11:38 pm #3097

    Thats great to hear 🙂

    Anonymous
    (Private)  August 6, 2014 at 9:27 am #3243

    Just to know…
    would be difficult to add a new date format, or to edit an existing date format?

    Ross Moderator
    (Private)  August 11, 2014 at 1:27 pm #3386

    Hey gianfranco

    Do you mean the display format from the plugin, or the backend format that is saved in the database? Frontend is not too difficult..

    The date format in the backend must match a format that can be compared numerically directly from the database – so we can perform searches.

    For example if you wanted to find posts within a date range, then the database query would look something like (this is extremely simplified):

    SELECT * FROM 'posts' WHERE datefield < '20140601' AND datefield > '20130101'

    Basically we have to be able to use operators like “greater than” and “less than” and this is only possible with numbers – not strings (so you cannot add regular characters such as hyphens).. this is also possible with a unix timestamp which is currently supported.

    Does that make sense?

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