Hi
I have a form collecting data and would like to only show data collected this year (not values from last year)
Is this possible using a SQL string somehow
I have never used SQL before so I'm very new to this all
You helped me last year with it to find records and show only certain fields
The code was this

SELECT
record,
title,
value
FROM
#__facileforms_subrecords
WHERE
name IN ('boat_name','LASTNAME','FIRSTNAME')
ORDER BY values DESC

What should I add to only show records submitted this year
The fieldname "Name" can be searched for "Registered2015" (as the form used was named like this, this year)
This could be one field to use for only showing this years participants

Sincerely,


Dominicus

Hello,

Could you send an SQL dump of #__facileforms_records table or provide a temporary access to your J! backend by email so we can ability to see structure of table(s)?

Regards,
ARI Soft