Ask Your Question

Is there a FUNCTION to Find #-days, from Order...Recpt ?

asked 2017-05-23 20:46:32 +0200

abi gravatar image

... or just =sum(d?-a?) ?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-05-23 21:12:21 +0200

If you have two dates, then number of days between the two dates is TRUNC(date2-date1). Actually, date (or equally time) is a float which contains number of days passed from "day zero". Fractional part is time represented as part of day (0.5 being equal to 12 hours = noon).

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-05-23 20:46:32 +0200

Seen: 26 times

Last updated: May 23 '17