A
AMIT HCL
In my Report (generated from a query) there are 4 Col.
Bill Date , Payment Date, Diff , Factor
Bill date : the date on which billing happened
Payment date : on which customer made payment to me .
Diff : Difference between billing & payment dates
Factor : it has to be displayed 1 if diff is <30 , 0.8 if Diff is between 30
to 60 , 0 if Diff is >60
I am having the both dates in my database table & can calculate the diff
also . But how to get the Factor value in text box .
Please HELP .
Bill Date , Payment Date, Diff , Factor
Bill date : the date on which billing happened
Payment date : on which customer made payment to me .
Diff : Difference between billing & payment dates
Factor : it has to be displayed 1 if diff is <30 , 0.8 if Diff is between 30
to 60 , 0 if Diff is >60
I am having the both dates in my database table & can calculate the diff
also . But how to get the Factor value in text box .
Please HELP .