CFDB: Trying to filter based on Date field

  • Hi Michael – Thank you for this wonderful plugin! I am setting up a form to reserve a room. People need to check a datatable to see if the room is already reserved for the time they want. I am trying to filter the cfdb-datatable so that rows with dates prior to today’s do not show, since there’s no need to check past dates. I’ve tried this:

    [cfdb-datatable edit=”true” form=”Reserve Zoom Time” filter=”strtotime(Date)>=strtotime(‘today’)” show=”from_name,Date,Time,Room” orderby=”Date,Time,Room” headers=”from_name=Coach,Date=Date,Time=Time,Room=Room”]

    Also tried filter=”strtotime(Date)>-1 day”

    The result is always that nothing shows up in the table.

    Thanks in advance for any suggestions you can provide.

    • This topic was modified 7 years, 1 month ago by mhurwicz.
  • The topic ‘CFDB: Trying to filter based on Date field’ is closed to new replies.