limit plugin help

[paulknox]

I have a form that I want users to be able to submit only once every 12 months. I have the limit plugin set-up on the form with the following.

User element: User ID
Limit length: 1

I'm trying to use the where clause to lookup the date then add 12 months... I have tried all sorts but the closed I have got is

DAYOFYEAR(passport.date_time)>DAYOFYEAR(CURDATE())

But of course this only works if the returned number is lower than the return date/time number.

I have tried DATEDIFF but this returns an error... Any thoughts??

Paul

 

[Sophist]

I have never used this plugin but I have taken a look at the the wiki for the Limit form plugin (which looks somewhat out of date) and the actual settings page.

Since this is an SQL WHERE clause, you are going to want MySQL date functions - a quick google search comes up with: https://www.w3schools.com/sql/func_mysql_date_add.asp

So you probably want something like:

passport.date_time > DATE_ADD(CURDATE(), INTERVAL -1 YEAR)

 

[Sophist]

P.S. You could get very very close with DATEDIFF (except for leap years):

DATEDIFF(CURDATE(), passport.date_time) < 365

 

[Sophist]

P.P.S. If this helps you, could you please update the wiki screenshot and description to match the current plugin version by way of a thankyou.