Comments Ryan Vaughan started the conversationDecember 6, 2019 at 1:13pmHi Support,Is it possible to use the %CURRENT_DATE% place holder within a filter? For instance, I only want to show data from yesterday, am I able to do %CURRENT_DATE%-1 ? If not within the filter itself, how about an SQL query?Thank youRyan 2,572Aleksandar repliedDecember 6, 2019 at 6:01pmHi Ryan.It's not possible to use it like that with a %CURRENT_DATE%-1 feature, but it is possible through the query.I believe you're looking for something like this: SELECT * from date_table WHERE date >= DATE_SUB(CURDATE(), INTERVAL 1 DAY)Or something similar to this, but I know these queries work without any issues when written properly.Kind Regards, Aleksandar Vuković[email protected] Rate my support wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community You can try wpDataTables add-ons before purchasing on these sandbox sites: Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables 2Srinath repliedJanuary 12, 2020 at 6:29amSimilar queries can be found here 2,572Aleksandar repliedJanuary 13, 2020 at 1:26pmThanks for your help Srinath!Kind Regards, Aleksandar Vuković[email protected] Rate my support wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community You can try wpDataTables add-ons before purchasing on these sandbox sites: Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables Sign in to reply ...
Hi Support,
Is it possible to use the %CURRENT_DATE% place holder within a filter? For instance, I only want to show data from yesterday, am I able to do %CURRENT_DATE%-1 ? If not within the filter itself, how about an SQL query?
Thank you
Ryan
Hi Ryan.
It's not possible to use it like that with a %CURRENT_DATE%-1 feature, but it is possible through the query.
I believe you're looking for something like this:
Or something similar to this, but I know these queries work without any issues when written properly.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Similar queries can be found here
Thanks for your help Srinath!
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables