Hello there!
I have a little problem with CC 5. I have a table with few fields and one of them is date, in format 0000-00-00. I populate the table using a form i made with ChronoForms V5. Now, I want to list records, ordered by the month. I'm trying to use MONTH(model.field) to extract the month from date in "Conditions" box, but it's not working.
Can someone please point me in the right directions?
Thank you very much, in advance!
I have a little problem with CC 5. I have a table with few fields and one of them is date, in format 0000-00-00. I populate the table using a form i made with ChronoForms V5. Now, I want to list records, ordered by the month. I'm trying to use MONTH(model.field) to extract the month from date in "Conditions" box, but it's not working.
Can someone please point me in the right directions?
Thank you very much, in advance!
Hi ionesko,
The conditions box is matching the WHERE clause, so how do you plan to use it for "Order" ?
Please try this in the "Order" box:
Regards,
Max
The conditions box is matching the WHERE clause, so how do you plan to use it for "Order" ?
Please try this in the "Order" box:
:MONTH(model.field)Regards,
Max
This topic is locked and no more replies can be posted.
