Filter by date(Y-m-d)

  • Resolved MikeKJ

    (@mikekj)


    8 years, 3 months ago

    The date is set in CF7 using a datepicker(
    WP Datepicker) and it saves a date to the form/database like Y-m-d (2017-03-06)
    I have set the date option in CFDB to be Y-m-d as well

    I have an entry in the databse with an Available-From as 2017-03-06 but this shortcode doesn;t return anything please tell me what I am doing wrong.

    [cfdb-table form=”Initial Application” hide=”Submitted,confirm_email-775,confirm_email-425,confirm_email-776,confirm_email-777,Submitted Login,Submitted From,submit_time” filter=”Available-From>=2017-03-01″]

    many thanks

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter MikeKJ

    (@mikekj)

    Tried this as well

    [cfdb-table form=”Initial Application” hide=”Submitted,confirm_email-425,confirm_email-775,confirm_email-776,confirm_email-777,Submitted Login,Submitted From,submit_time” filter=”Available-From~~/.*$_POST(df).*/i]

    <form action=”” method=”POST”>
    <!–First Name: <input type=”text” name=”fname” />
    Last Name: <input type=”text” name=”lname” /> –>
    Available From: <input type=”text” name=”df” />
    <input type=”submit” />
    </form>

    Plugin Author Michael Simpson

    (@msimpson)

    See: https://cfdbplugin.com/?page_id=1195

    Thread Starter MikeKJ

    (@mikekj)

    Brilliant, thank you.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Filter by date(Y-m-d)’ is closed to new replies.