Hello John
There are two approaches to this.
1) Best, save date into table as a number. Select date like
WHERE date>=$date1 AND date<=$date2
2)Otherwise, if storing dates a strings:
WHERE date=$date1 OR date=$date2 OR date=$date3 OR date=$date4 OR
date=$date5.....
In general, if you want to select date ranges and perform other date
calculations, save the date as a unix date number then convert to human
readable form as necessary.
John Berman wrote:
Hi
I'm struggling with some logic
I have a table called: submissions and each record has an approvedate field
which stores the date mm/dd/yyyy
I want to display all records for 7 days only from their approved date so I
guess something like
Select * from submissions were approvedate - this is were im getting stuck
Pointers appreciated, im sure its simple ?
Regards
John B
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]