How can we get difference between two times ?

Question

Hi All, 
 I am having two times saves in 2 variables 
 Eg: 1) 2/5/2023 9:00 AM GMT+05:30. 2) 2/5/2023 8:00 PM GMT+05:30 
 now my ask is what function we should use in order to get the output like output : 11 hrs or in minuts 
 and also same for dates 
 Thank you

frankt54 · Answer

I don't know if this is what you are looking for, but you can use a!elapseTime and then map the result like the picture below.

Mike Schmitt · Answer

Generally you can just subtract a datetime value from another, it just takes some effort to meaningfully unpack the result. Here's my quick attempt at something simple: a!localVariables(
 
 local!time1: datetime(2023, 02, 05, 09, 04), 
 local!time2: datetime(2023, 02, 05, 20, 02),
 
 local!difference: local!time2 - local!time1,
 
 a!map(
 days: tointeger(local!difference),
 hours: hour(local!difference),
 minutes: minute(local!difference),
 )
)

Yanal · Answer

After.. decrypting.. your question, I understood that you want to find the difference in time between 2 date/dateTime values, here you go mate; this should help: a!localVariables(
 local!firstDateTime: now(),
 local!secondDateTime: subtractminutes(subtracthours(now(), 4), 15),
 local!timeDifference: elapsedtime(
 local!secondDateTime,
 local!firstDateTime
 ),
 a!map(
 mintuesDifference: local!timeDifference[5],
 hoursDifference: local!timeDifference[4],
 dateDifference: elapseddays(
 local!secondDateTime,
 local!firstDateTime
 ),
 hoursWithMinutes: time(
 local!timeDifference[4],
 local!timeDifference[5]
 )
 )
) also consider checking these sections for later requirements on date manipulations.

Yanal · Answer

ah, so you don't have the plugin, my bad, here's the equivalent of the above but by using Appian built-in functions: a!localVariables(
 local!firstDateTime: now(),
 local!secondDateTime: now() - intervalds(28, 15, 0),
 local!differenceTimeValue: timevalue(
 local!firstDateTime - local!secondDateTime
 ),
 a!map(
 mintuesDifference: minute(local!differenceTimeValue),
 hoursDifference: hour(local!differenceTimeValue),
 hoursWithMinutes: local!differenceTimeValue,
 dateDifference: days360(
 local!secondDateTime,
 local!firstDateTime
 )
 )
) edit: note that if you want to get the total hours or minutes difference, then you should add the hours or minutes with the days difference (* 24) or (* 24 * 60 (incase of the minutes)) .

How can we get difference between two times ?

Top Replies