Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to excude saturday , sunday & Holiday from date interval-
Interval
(Resolved-[Requested Date],'d hhmm:ss')
Please help
use NetworkDays.
This will allow you to create the number of Monday to Friday days in your values together with a list of holiday dates at the end that will be excluded.
Hope this helps
networkdays( start_date, end_date {, holiday} )
Returns the number of working days (Monday-Friday) between and
including start_date and end_date taking into account any optionally
listed holidays. All parameters should be valid dates or timestamps.
Example:
networkdays ('2007-02-19', '2007-03-01') returns 9
networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-
26') returns 8