DateTimeDiff() on minutes doesn't work as intended

[kelvenlim]

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.

[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 · Accepted solution]

Hi @kelvenlim 

Please find the expected output.

Many thanks

Shanker V

[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

[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.

[ShankerV]

Hi @kelvenlim 

Datetimetoday() will give only today's date with time as 00:00:00

Datetimenow() will give today's date with current time too.

Many thanks

Shanker V