DateTimeDiff() on minutes doesn't work as intended
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Date Time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ShankerV I edited the post. Are both images okay now?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
