Lots of ways. What's your tables structure? Do you need this in a stored proc or there's a front-end apps that handles the two dates?
-- CK
Hi can you please send me a script for this
my requirement is , i need to generate dates between two dates and store in a table, eaxmple i take the current date as end date and a date which is six month old, it needs to insert all dates inbetween it
my table is
CREATE TABLE emp_attendence (
attend_date datetime default '00-00-0000',
PRIMARY KEY (attend_date)
) TYPE=MyISAM;
can you mail me the script to mailsarin@yahoo.com
thanks in advance