Forums › Forums › Search & Filter Pro › Date Input Format for Date Filters

Tagged: ,

Viewing 3 posts - 1 through 3 (of 3 total)
  • Anonymous
    (Private)  March 27, 2017 at 4:50 am #99580

    Hi,

    Is it possible for the Search and Filter Pro plugin to filter on metadata date values using a dd/mm/yy format in the database instead of the yyyymmdd format?

    I realized when I was trying to search/filter custom post types with a dd/mm/yy date field in my database, then the post wouldn’t show up because it didn’t recognize the dd/mm/yy format.

    Thanks!

    Trevor
    (Private)  March 27, 2017 at 8:49 am #99597

    It isn’t, because of the way SQL saves dates in the format you request. Many custom field plugins now have the option to save in the 20170327 (today) type format specifically to support filtering. For example, ACF does, calling this format yymmdd. Many datepickers do the same.

    Anonymous
    (Private)  March 28, 2017 at 2:24 am #99834

    Hi Trevor,

    Got it, thanks for the confirmation!

    That answers my question.

    Best,

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