Converting to time?

tiagofrancis

Hi folks..

I'm having some issues converting some data to time.

I need to convert two fields of my table to time, fieldHour and fieldMinute.
Both are integer. How can i convert them to time? =;


Thanks in advance.

kine

You can try something like:

 EVALUATE(MyTime,FORMAT(fieldHour,0)+':'+FORMAT(fieldMinute,0));

It means creating string from your values and convert this string into Time datatype... ;-)

jreynolds

Convert your hours and minutes to milliseconds since midnight and add to midnight.

000000T + ((Hour * 60) + Minute) * 60000)

kriki

jreynolds wrote:

Convert your hours and minutes to milliseconds since midnight and add to midnight.

000000T + ((Hour * 60) + Minute) * 60000)

This is better, because it is possible the divider between HH and MM and SS is not ":" but ".". I have to admit I don't know if Navision would accept it or not.