oracle
12-06-2005, 02:39 AM
How do I calculate 60days from a field in ms access? How would the sql query go?
currently my query goes this way:
:confused: if u_field= "Ageing" and rs("inception_date") = "" then
sql =
"Select * from Risk_Acceptance where where Risk_Status ='Not Taken Up' and "_
& "(inception_date - date > -60 and inception_date - date < '%%"& u_input & "%%')"
I'm working on report which would display records which are over 60days from it's inception date....if the record has no inception date then it'll read the date of offer field. Furthermore, the user would select base on month, meaning, if the user enters 3 months, records between the 61-90days should be return. The selection is base on ageing.
Please someone help me out here.:(
currently my query goes this way:
:confused: if u_field= "Ageing" and rs("inception_date") = "" then
sql =
"Select * from Risk_Acceptance where where Risk_Status ='Not Taken Up' and "_
& "(inception_date - date > -60 and inception_date - date < '%%"& u_input & "%%')"
I'm working on report which would display records which are over 60days from it's inception date....if the record has no inception date then it'll read the date of offer field. Furthermore, the user would select base on month, meaning, if the user enters 3 months, records between the 61-90days should be return. The selection is base on ageing.
Please someone help me out here.:(