Sorry for the late reply
I have tried it in 2 database,
In 2009 r2 it shows 1 day 13 hours 34 minutes
In 2016 it shows 1.13:34:00
I cannot change the 2009 R2 to show it in excel date time format
Date
Votes
4 comments
-
Jet Reports Historic Posts I have a field in Navision, type = Duration, so it presents 1 day 3 hour 15 minutes
It should be a bigint type in the database containing the value in milliseconds, but I cannot get it to come through as a decimal I can add up
Anyone come across this before
Regards -
Jet Reports Historic Posts In my sample database, fields of type Duration (not to be confused with fields *named* Duration) are presented in the format: n.nn:nn:nn
for example:
If I wanted to add up those, I would need to use a formula to convert them.
When you query your field, how is it formatted? (is this a standard NAV table & field?) -
Jet Reports Historic Posts Thanks for the additional information (about working with 2009R2).
I elected to use string manipulation to get the values I wanted.
Attached is an example working the the duration field "Idle Time" (in the Session table)
I hope it helps. -
Jet Reports Historic Posts Thanks for your time, I understand you can use string manipulation ,but the data in the SQL database is in milliseconds, so is presented as 864000, not 12 hours 13 minutes etc
I have gone back to Jet to ask if we can override the caption reporting to use the raw data which would make it a lot easier on the end user for the reports
Regards
Please sign in to leave a comment.