CB Query for calculating difference between dates

Hi
I am using CB 2 with the query plugin and content plugin. I am trying to do a substitution that shows content to people who have been attending classes for longer than x days.

In order to work out x days I have a field called cb_classstart which is a date. I would like to have a field called cb_daysdiffquery that calculates the number of days between the start date and the current date however I am not sure of the calculation please and I was hoping you could help me to achieve this.

My plan is to then use a substitution that is something like


[cb:if cb_daysdiffquery > 1]Content I want to show[cb:else]This content is not available yet and will be available after 1 day.[/cb:else][/cb:if]

I look forward to hearing from you.

Thank you
Andrew

See the below MYSQL function documentation. Please understand we're not here to teach you coding or provide custom code on demand.

dev.mysql.com/doc/refman/5.6/en/functions.html

Specifically you'll need to utilize date functions.

dev.mysql.com/doc/refman/5.6/en/date-and-time-functions.html

You can probably just do a SELECT of the datediff of the 2 dates then condition against the datediff value in your IF substitution.

dev.mysql.com/doc/refman/5.6/en/date-and-time-functions.html#function_datediff