Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys,
I need to calculate the number of days of a case = date_modif - date_creation without counting saturday and sundays, only working days
the two field date has this format : 8/28/2017 8:37:40 AM
Any idea ?
Thanks
Use NetWorkDays() function
NetWorkDays(date_creation, date_modif)
May be this?
If(Not WildMatch(WeekDay(date_modif) and WeekDay(date_creation), 'Sat', 'Sun'), date_modif - date_creation)
OR
If(Not WildMatch(WeekDay(date_modif) and WeekDay(date_creation), 'Sat', 'Sun'), Interval(Date(Date#(date_modif,'M/DD/YYYY hh:mm:ss TT'),'DD-MM-YYYY') - Date(Date#(date_creation,'M/DD/YYYY hh:mm:ss TT'),'DD-MM-YYYY'), 'DD'))