i have project and i want to get the expire date
by make 2 feilds in the form like .....
from................... to....................
and i want to get every date between these dates...
please help me by send the code if u could
and thank for every one ..........

no answer.no broplem.
i have to keep quite
thank u

select *
from person
where birthdate between :date and date2;

not
date is item
date2 is item

ehab wagdi

thank u for ur responsing but i want
to make it more clear for u
''''
i have only one column in the table and
in the form i have to items
and i want to get the date from
that column''''
suppose i want to search for the every medicine will expire
between 2 dates'''
so wt can i do in that case'''
remember u that i have only one column for date
in the table
thank

ايه المشكله
اعتقد ان حل الاخ ehab wagdi

يفى بالغرض

select med_code from medicin where exp_date between :from_date and to_date

يا ريت تجرب الحل
او انا مش فاهم قصدك

وشكرا

no use
plz help
thank u

plz brothers

الحل كما قال الأخ الكريم

تم تعديل 17 مارس 200620 سنة بواسطة mah_dba

اخى الكريم الحل بسيط و سهل

select col1,col2 into :text_item4,:text_item5 where col_date between :text_item1 and :text_item2;

هذا و الله اعلم
Oracle ITself

thank for everyone
but as i know it is not
allowed to use function on
feild from form
example
between :date.date1 and :date.date2
wrong sentance
;

Ok u can get that values of the two text items .. and put it into two varibles with suitable data types and then make the comparsion .. and make the accurate query ..

or meet me on messenger and i will solve it for u online

هذا و الله اعلم

Oracle ITself