How to get working days between 2 time stamps

Hello likhithan 

You can test out the calworkdays(). Here is a reference for documentation calworkdays(). Have you tried converting epoch values and calculate when it comes to seconds?  It would return epoch seconds and you can convert into days. 

I have tried calworkdays() but no use becasue when I have time stamp with in same day lets say [3/11/2024 9:24 AM EDT] and [3/11/2024 9:26 AM EDT] then here the difference is just  2 min right . But when I use this function, days will be coming as 1 but difference between these two dates we cannot expect days as 1

Yes. You will have to construct your expression rule to calculate the difference based on the below values


Also I would say try out these for better understanding

I can understand the above mentioned way is a complex one. But the conversion of your date times will give you accurate values.

Can you please check my code. I have sent . The way you are saying like how can I eliminate weekends there

i think then you need to calculate works hours initially 

If I calculate initially then I will be getting 1 day with the dates I mentioned in the output. The the output cannot be 1 day because time difference in only 2 minutes

Konduru Chaitanya  any suggestion here after seeing my code

a!localVariables(
  local!date1: (
    "Your date time 1 here" - todatetime("01/01/1970")
  ) * 24 * 60 * 60,
  local!date2: (
    "Your date time 2 here" - todatetime("01/01/1970")
  ) * 24 * 60 * 60,
  local!getEpochfor1: index(split(local!date1, ":"), 1, null),
  local!getEpochfor2: index(split(local!date2, ":"), 1, null),
  local!difference: local!getEpochfor2 - local!getEpochfor1,
  local!days: rounddown(local!difference / 86400, 0),
  local!hours: rounddown(mod(local!difference / 3600, 24), 0),
  local!minutes: rounddown(mod(local!difference / 60, 60), 0),
  local!sec: rounddown(mod(local!difference, 60), 0),
  concat(
    local!days,
    " Days",
    " ",
    local!hours,
    " Hours",
    " ",
    local!minutes,
    " Mins",
    " ",
    local!sec,
    " Secs"
  )
)

Try replacing your date time values in the local!date1 and local!date2. Not sure how accurate it works for all values. But as far as I am getting for different values, it is giving me the expected answer

Sure I will check once. Thanks. Did your code remove weekends here

a!localVariables(
  local!date1: datetime(2024, 4, 11, 13, 24, 41, 0),
  local!date2: datetime(2024, 4, 15, 13, 24, 41, 0),
  local!getEpochfor1: index(split(local!date1, ":"), 1, null),
  local!getEpochfor2: index(split(local!date2, ":"), 1, null),
  local!difference: local!getEpochfor2 - local!getEpochfor1,
  local!days: rounddown(local!difference / 86400, 0),
  local!hours: rounddown(mod(local!difference / 3600, 24), 0),
  local!minutes: rounddown(mod(local!difference / 60, 60), 0),
  local!sec: rounddown(mod(local!difference, 60), 0),
  concat(
    local!days,
    " Days",
    " ",
    local!hours,
    " Hours",
    " ",
    local!minutes,
    " Mins",
    " ",
    local!sec,
    " Secs"
  )
)

Here difference should be only 4 days but I am getting 15 hours and so on extra

You are not supposed to replace the complete value from the local!date1. I have mentioned the place where your date should be added.

a!localVariables(
  local!date1: tointeger(
    (
      datetime(2024, 4, 11, 13, 24, 41, 0) - todatetime("01/01/1970")
    ) * 24 * 60 * 60
  ),
  local!date2: tointeger(
    (
      datetime(2024, 4, 15, 13, 24, 41, 0) - todatetime("01/01/1970")
    ) * 24 * 60 * 60
  ),
  local!difference: local!date2 - local!date1,
  local!days: rounddown(local!difference / 86400, 0),
  local!hours: rounddown(mod(local!difference / 3600, 24), 0),
  local!minutes: rounddown(mod(local!difference / 60, 60), 0),
  local!sec: rounddown(mod(local!difference, 60), 0),
  concat(
    local!days,
    " Days",
    " ",
    local!hours,
    " Hours",
    " ",
    local!minutes,
    " Mins",
    " ",
    local!sec,
    " Secs"
  )
)

You are not supposed to replace the complete value from the local!date1. I have mentioned the place where your date should be added.

a!localVariables(
  local!date1: tointeger(
    (
      datetime(2024, 4, 11, 13, 24, 41, 0) - todatetime("01/01/1970")
    ) * 24 * 60 * 60
  ),
  local!date2: tointeger(
    (
      datetime(2024, 4, 15, 13, 24, 41, 0) - todatetime("01/01/1970")
    ) * 24 * 60 * 60
  ),
  local!difference: local!date2 - local!date1,
  local!days: rounddown(local!difference / 86400, 0),
  local!hours: rounddown(mod(local!difference / 3600, 24), 0),
  local!minutes: rounddown(mod(local!difference / 60, 60), 0),
  local!sec: rounddown(mod(local!difference, 60), 0),
  concat(
    local!days,
    " Days",
    " ",
    local!hours,
    " Hours",
    " ",
    local!minutes,
    " Mins",
    " ",
    local!sec,
    " Secs"
  )
)

Can I know why you used there 1970 something date like that 

Google search on Epoch time?

I got it . Thanks a lot . Now should I use calworkdays fucntions to remove weekends  here now

Actually with my code also I am getting the same output but my problem here is to remove weekends