Can anyone tell me more on time calculation of tssma301. Time shown in this table is in integer format and is in the form of 00:00.

Is any standard function is available to convert this format or calculate the time difference between two of these values.

Thanks in advance.

Regards,
;)

I alway though that time in Baan was held in number of seconds after midnight so in format 00:00 is new to me.

Hi Peayoosh,

We also have Service module implemented. For calculation I had tried and did not find any function and then we customised reports based on our own calculation. If you are still interested, please let me know and i will be able to share the same. If you have found another way of doing it, please let me know.

Can anyone tell me more on time calculation of tssma301. Time shown in this table is in integer format and is in the form of 00:00.

Is any standard function is available to convert this format or calculate the time difference between two of these values.

Thanks in advance.

Regards,
;)

Table tssma301 has ddt1 (Orderdate) , dtm1 (Ordertime) and
ddt2 (servicedate) . dtm2 (Servicetime)
therefor you have to calculate the difference between date and time.
datediff can be calculated with (ddt2 - ddt1) in days
time is stored in seconds since midnight
calculate difference of dtm1 and dtm2 gives difference in seconds.

Regards Bernd