Data Type Duration

achach Member Posts: 16
edited 2004-06-17 in Navision DOS

Please help, I have a field named "Time Spent" which is of data type duration, the value that is shows includes Days,Hours,Minutes,Seconds,Milliseconds, how can I stop it from showing the milliseconds.

Many Thanks


  • RobertMoRobertMo Member Posts: 484
    when calculating duration round it to thousands like ROUND(TimeSpent,1000)
Sign In or Register to comment.