Hi, I have a table like : ID date_from date_to price_code price dateadded 1 07:10:2006 31:12:2099 p1 10 07:10:06 2 17:10:2006 31:12:2099 p1 20 07:10:06 3 27:10:2006 31:12:2099 p1 10 07:10:06 4 01:11:2006 31:12:2099 p1 20 07:10:06 5 05:10:2006 31:12:2099 p1 20 08:10:06 6 10:10:2006 31:12:2099 p1 20 08:10:06 7 25:10:2006 31:12:2099 p1 20 08:10:06
Basically there are price codes and the price , i have to find the effective price for the date today. The price must be calculated also on the latest added date. Pl. help me. I shall be very grateful. -- Regards, Abhishek jain
