dates difference

[master_student]

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

[sunny_talwar · Accepted solution]

Use NetWorkDays() function

NetWorkDays(date_creation, date_modif)

[Anil_Babu_Samineni]

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'))