I have a table that queries a MYSQL db and one of the columns is a datetime stamp. I would like to know if it's possible to only display rows/records that only have datetime stamps that have not yet occurred. In other words, once the time, in this case an appointment, is reached, it will no longer be displayed in an "Upcoming Appointments" table. It will, however, then appear in the past lesson table.
Hi,
I have a table that queries a MYSQL db and one of the columns is a datetime stamp. I would like to know if it's possible to only display rows/records that only have datetime stamps that have not yet occurred. In other words, once the time, in this case an appointment, is reached, it will no longer be displayed in an "Upcoming Appointments" table. It will, however, then appear in the past lesson table.
Thanks and kind regards,
Jack
HI Jack,
Thank you for your purchase.
Something like this can be achieved by writing a query that will only return the results from the days that are after todays date.
Or you can use our conditional formatting to color the cells of that dates based on today date.
You can find more information on this link.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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