I have a query that subtracts 2 dates and give me the amount of days in between, (simple!!).
My problem is that I need to do this calculation on a 360 days per year basis, and not on 365 days. How do I do this????.
(ex in Excell: 30/06/00-01/01/00= 179 (Function in Excell =DAYS360(A10,B10))The amount I get is 181 days because of the 365 days., but I need the first one)
There is a function in Excell called DAYS360 that does this, but I need to do this in Access.
Please help. [sig][/sig]
My problem is that I need to do this calculation on a 360 days per year basis, and not on 365 days. How do I do this????.
(ex in Excell: 30/06/00-01/01/00= 179 (Function in Excell =DAYS360(A10,B10))The amount I get is 181 days because of the 365 days., but I need the first one)
There is a function in Excell called DAYS360 that does this, but I need to do this in Access.
Please help. [sig][/sig]
