po 7. 6. 2021 v 21:17 odesÃlatel Ron <[email protected]> napsal:
> On 6/7/21 2:12 PM, David Gauthier wrote:
>
> Hi:
>
> I suspect I'm not the first to ask about this but couldn't find anything
> after googling for a bit. So here goes....
>
> I'd like to get the "age" difference between two times which span either
> all or part of a weekend but exclude any time that transpired during the
> weekend.
> Example (please pardon the non-timestamp vals here...)
>
> age('Monday-Noon','Prev-Friday-Noon')
> would give me '1 day'.
>
> ...and...
>
> age('Sunday-Noon','Prev-Friday-Noon')
> would give me '12 hours'
>
> You get the picture.
>
> Has this wheel already been invented ?
> I don't see an easy way to do this off-hand.
> All Ears :-)
>
> Thanks in Advance.
>
>
> You seem to be asking about counting work days. Am I misunderstanding?
>
orafce has functions for business calendar with holidays
https://github.com/orafce/orafce
plvdate.add_bizdays(day date, days int) date
Regards
Pavel
> --
> Angular momentum makes the world go 'round.
>
