To Calculate workdays between 2 dates (DateTime)

Question

To Calculate workdays between 2 dates I have used function calworkdays. But the days are not getting calculated properly. 
 I need to get workdays between dates 7/17/2018 9:06 pm and 7/18/2018 8:41 pm, which should come as 1 but I am getting 2. 
 So, basically I want to consider not only the date but also the time to know the days between 2 dates.

ekanshj · Answer

Hi, 
 
We don't have any out of the box thing for this. calworkdays will calculate calculate days including the dates. 
Try to subtract the two dates, you will get the interval type data which you need to manipulate with according to the requirement like converting it to string then splitting it. 
 
Thanks 
Ekansh

deviratnamv · Answer

Hi Diptis, 
If you want to calculate the total number of days in between two dates (including weekends, holidays, and other designated non-working days) you don't need to use this function. Simply subtract date 1 from date 2, as in the following example: 
pv!date2-pv!date1