Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
Please help in calculating no. of days in the below data file.
[Issue key] | Created | Created_Date | Created_today | (today()-Created_Date)+1 |
GEMPRODSUP-4275 | 04/May/18 2:07 PM | 04/05/2018 | 11/05/2018 | 8 |
GEMPRODSUP-4279 | 04/May/18 4:43 PM | 04/05/2018 | 11/05/2018 | 8 |
GEMPRODSUP-4234 | 03/May/18 9:52 AM | 03/05/2018 | 11/05/2018 | 9 |
GEMPRODSUP-4235 | 03/May/18 9:57 AM | 03/05/2018 | 11/05/2018 | 9 |
GEMPRODSUP-4236 | 03/May/18 9:59 AM | 03/05/2018 | 11/05/2018 | 9 |
GEMPRODSUP-3976 | 26/Apr/18 7:24 PM | 26/04/2018 | 11/05/2018 | 16 |
GEMPRODSUP-3977 | 26/Apr/18 7:59 PM | 26/04/2018 | 11/05/2018 | 16 |
GPS-2734 | 26/Apr/18 2:31 PM | 26/04/2018 | 11/05/2018 | 16 |
GEMPRODSUP-3864 | 25/Apr/18 9:34 AM | 25/04/2018 | 11/05/2018 | 17 |
GEMPRODSUP-3865 | 25/Apr/18 9:51 AM | 25/04/2018 | 11/05/2018 | 17 |
GEMPRODSUP-3866 | 25/Apr/18 10:26 AM | 25/04/2018 | 11/05/2018 | 17 |
GEMPRODSUP-4380 | 09/May/18 5:21 PM | 09/05/2018 | 11/05/2018 | 3 |
GEMPRODSUP-4382 | 09/May/18 6:07 PM | 09/05/2018 | 11/05/2018 | 3 |
GEMPRODSUP-4333 | 08/May/18 8:32 AM | 08/05/2018 | 11/05/2018 | 4 |
Thanks and regards,
Shruti Thakur
Where is the list of Holidays?
Check the function networkdays, firstworkdate, lastworkdate
The functions returns date or days between and including start_date and end_date taking into account any optionally listed holiday.
Below is the sample example