4,184
Hi All,
I've converted my time to e.g 11:40:53 to integer variable Hour=11 then Minutes:40 seconds:53 now my question is how to convert the Integer variables to time ?
*This post is locked for comments
I've resolved my issue. I've written a blog on it
Hi,
In the example above if you use - EVALUATE(MyTime,'114053');
That means 11 hours, 40 minutes and 53 seconds.
Try this evaluate statement and let me know how it works.
There's no a direct conversion. You need to create a custom function that performs what you want.
From an integer you can obtain a TIMe in this way:
message(format(000000T + (YOURINT * 10000)));
Hi,
If you know you parameters of time like -
1. Hours.
2. Minutes.
3. Seconds.
then you can use EVALUATE(MyTime,'114053');
** Where MyTime is a Time Variable.
The System will save value in MyTime variable as - 11:40:53 AM
** For NAV it's a 24-hour clock.
Let me know if any questions.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (