DIFF

master_student — Tue, 24 Oct 2017 16:14:17 GMT

Hello Guys,

I need your help, I need to get the difference between two date that have that format :

Creation date 22/10/2017 12:33:35

Last modification date 23/10/2017 08:01:41

I need to get the result in hours : minitues without counting sundays

Thanks

Re: DIFF

its_anandrjs — Tue, 24 Oct 2017 16:33:21 GMT

Try Interval match function

if( NOT Match(Weekday([Last modification date]),'Sun') and NOT Match(Weekday([Creation date]),'Sun') ,

Interval([Last modification date] - [Creation date] , 'mm')) as Difference