DateTimeDiff() on minutes doesn't work as intended

The first image shows the times in 24h and string format.

The second image shows me using datetimediff() on the current date and the field, and giving me the minutes. But after executing, it gives me a super big number. Does anyone know what's wrong?

Thank you.

Date Time

Accepted answers

ShankerV

Hi @kelvenlim

Please find the expected output.

Many thanks

Shanker V

datetimediff.yxmd

All comments

ShankerV

Hi @kelvenlim

Both the images are same.

So could see the time used. Please can you help on the time used in first screenshot.

Many thanks

Shanker V

kelvenlim

@ShankerV I edited the post. Are both images okay now?

ShankerV

Hi @kelvenlim

Please find the expected output.

Many thanks

Shanker V

datetimediff.yxmd

ShankerV

Hi @kelvenlim

As per the image I understand you remove the date and use only time.

Hence I am also getting the same random number in minutes,

Actually we need some date to get the right output.

Hence today's date is added to to get the desired output.

I have tried to achieve the result in one tool also as below.

Many thanks

Shanker V

One tool datetimediff.yxmd

kelvenlim

Thank you @ShankerV .

Turns our datetimetoday() and datetimenow() are different. I thought they would give the same result. The tables values are now showing what I expected.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280