Difference between duration time

Answers

• Options

  sharon95 Member Posts: 183

  2017-12-18

  I tried with FormatDateTime(Sum(Fields!TimeToG.Value - Fields!TimeFromG.Value),DateFormat.LongTime) but it doesn't work...

  0
• Options

  logger Member Posts: 126

  2017-12-18

  Hi @sharon95 ,
  I can be obvious, but what if to calculate this difference in NAV code and then send calculated value to the report?

  Let's go!
  

  0
• Options

  sharon95 Member Posts: 183

  2017-12-18 edited 2017-12-18

  logger wrote: »

  Hi @sharon95 ,
  I can be obvious, but what if to calculate this difference in NAV code and then send calculated value to the report?

  
  It always gives me an error....

  0
• Options

  logger Member Posts: 126

  2017-12-18

  @sharon95 ,
  Could you attach a screenshot of error message?

  Let's go!
  

  0
• Options

  sharon95 Member Posts: 183

  2017-12-18

  logger wrote: »

  @sharon95 ,
  Could you attach a screenshot of error message?

  
  simply "#Error" in the report field

  0
• Options

  logger Member Posts: 126

  2017-12-18

  @sharon95 , even if you calculate the difference in code? How do you do it?

  Let's go!
  

  0
• Options

  sharon95 Member Posts: 183

  2017-12-18

  logger wrote: »

  @sharon95 , even if you calculate the difference in code? How do you do it?

  
  in code I get type conversion error even if all three variables are Time.
  I'm trying ElapsedTime := TimeTo - TimeFrom; ...

  0
• Options

  logger Member Posts: 126

  2017-12-18

  @sharon95 ,
  Please, attach a screenshot of type conversion error.

  Let's go!
  

  0
• Options

  sharon95 Member Posts: 183

  2017-12-18

  Type conversion is not possible because 1 of the operators contains an invalid type. Time := Integer

  0
• Options

  sharon95 Member Posts: 183

  2017-12-18

  if I write Sum(Fields!TimeToG.Value - Fields!TimeFromG.Value) in the report I get the milliseconds.... any help?

  0
• Options

  logger Member Posts: 126

  2017-12-18

  @sharon95 ,
  You can just multiply it by 1000 to get seconds.

  Let's go!
  

  0
• Options

  sharon95 Member Posts: 183

  2017-12-18

  logger wrote: »

  @sharon95 ,
  You can just multiply it by 1000 to get seconds.

  
  it seems it doesn't work

  0
• Options

  logger Member Posts: 126

  2017-12-18

  @sharon95 ,
  Why do you think so? What was the value os milliseconds and what you get multiplying by 1000?

  Let's go!
  

  0
• Options

  Slawek_Guzek Member Posts: 1,690

  2017-12-18 edited 2017-12-18

  The Duration type is stored/calculated as a number of milliseconds.
  
  It can be assigned to/from an integer, or BigInteger vars. If you need a number of seconds you need to divide the duration by 1000, not to multiply it by 1000.
  
  Try this:

  ElapsedTimeMilisecondsBigInt := TimeTo - TimeFrom;
  ElapsedTimeSecsondsInt := ROUND( ElapsedTimeMilisecondsBigInt/ 1000.0, 1);
  ElapsedTimeDuration  := ElapsedTimeSecsondsInt * 1000; //back to miliseconds
  ElapsedTimeDurationTxt := FORMAT(ElapsedTimeDuration);
  

  Pass both ElapsedTimeSecsondsInt and ElapsedTimeDurationTxt vars in your data item, then use the text version to display the individual lines duration and ElapsedTimeSecsondsInt to add up the number of seconds.
  
  The ElapsedTimeDuration var is of Duration type, and is used in the example to get proper formatting.
  
  Using of BigInteger in ElapsedTimeMilisecondsBigInt in this case is non-essential as you are only dealing with Time variables, but it is good to get using it as your general habit when dealing with duration, as when you start comparing/formatting datetimes the duration can go out of allowed integer values range easily.

  Slawek Guzek
  Dynamics NAV, MS SQL Server, Wherescape RED;
  PRINCE2 Practitioner - License GR657010572SG
  GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03

  0