DMY2DATE with TIME

aleix1979

Hi there, :P

Do you know of any function in Navision that would do the same that DMY2DATE but with time?

That is, that given three integer vars (hour,minute,second) creates a TIME variable.

Thanks in advance

kine

There is no such a function, but you can use

EVALUATE(MyTime,FORMAT(Hour)+':'+FORMAT(Minutes)+':'+FORMAT(Seconds));

jreynolds

You can convert your hours, minues, and seconds to an integer number of milliseconds and then add this result to midnight (000000T).