Convert a numeric field to HH:mm:ss

system · December 23, 2011, 6:29pm

Hi!

I work on the new Web 4.0. I have a numeric field containing the amount of secunds of a certain dimension. I would like to display the field as hh:mm:ss. For example 74 to be shown as 00:01:14

I know i should push this function to the universe or the dbse server (Microsoft actually) but there are a lot of calculation that have to be done in WebI…

In advance thank´s for many ansvers!

Olalav

olalav (BOB member since 2008-10-27)

system · December 23, 2011, 6:41pm

Hi,

Try a formula from this old topic:

You need to convert the syntax from DeskI to WebI, should be simple.

Marek Chladny (BOB member since 2003-11-27)

system · December 29, 2011, 8:49am

Thank’s for your answer! I already found this one earlier but did not manage the conversion to WebI 4.0!

I’ll try again!

Olalav

olalav (BOB member since 2008-10-27)