Selecting records from 12 month date range from 4 digit year.

Hi,

I started to post this question in the SA forum because I want this criteria to control login, but I also want to use it on other pages in recordsets (select statements, queries). Please forgive my lack of knowing the correct terms.

For many of our club activities, especially logging into the Members Only page (login pages created with SA), I would like to be based on the member being current in their dues. I have a column “Dues_Paid” which contains the 4 digit year that the member has paid and is considered “Current”. The date range of December 1st to the following November 30th further defines “Current”

What php code would I add (to the select statement) to select records where “Dues_Paid” equals any date within the range of December 01 to November 30 of the current year?

As I am a rookie please be as specific as possible with your suggestions.

Thanks,
Dennis

what i would do is this.

store the date the dues payment was made, (YYYY-MM-DD) in your database.

in order to negate the need to change the 'active year' you could use some php using the current date.

For example...

if the current month is December, your active year is 1st december of this year to 30 november of next year.

if the current month is not December, your active year is 1st december of last year to 30 november of this year.

you can do that with something like this...

<?php 
$activestartdate = (date('m')<12?date('Y')+1:date('Y')).'-12-01';
$activeenddate = (date('m')<12?date('Y'):date('Y')+1).'-11-30';
?>

you can then use these variables in your sql statement using datediff() to determine whose dues were paid within the active year

using a simple table as an example, with fields memberid, membername and paydate, i constructed a page with a recordset to return only the members whose payment was made in the active year.

you can find out more about the mysql function datediff here...

func_datediff_mysql.asp

Happy New Year to All,

Craig,

Thank you very much for your suggestion and example code, I appreciate it a lot. I haven't had a chance to go through it yet, I will in the next few days. But I wanted to post my thanks.

Dennis