Data Type Duration

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

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

Comments

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