How to calculate time based on Start date and End Date ?

chandrurecchandrurec Member Posts: 560
edited 2013-08-14 in NAV Three Tier
Hi all,

I want to calculate no of time between start date , end date, start time and end time.

I need to display the result in minutes.

If anyone know how to achieve, kindly share.

Thanks in advance.

Regards,
chandru.

Comments

  • thegunzothegunzo Member Posts: 274
    Here is an example
    D := ROUND((CREATEDATETIME(EndDate,EndTime) - CREATEDATETIME(StartDate,StartTime)) / 60000,1);
    MESSAGE('%1 Minutes',D);
    
    ________________________________
    Gunnar Gestsson
    Microsoft Certified IT Professional
    Dynamics NAV MVP
    http://www.dynamics.is
    http://Objects4NAV.com
Sign In or Register to comment.