topic Time() or Timestamp() formatting for INTEGER value(s) in App Development

Time() or Timestamp() formatting for INTEGER value(s)

vlad_komarov — Wed, 13 Jun 2018 00:40:41 GMT

Dear all,

I am looking for simple way to display Timestamp data for Integer values.

Like 1 = 24:00:00, 2 = 48:00:00, etc

Using Time() or TimeStamp() does not help, it's always displaying 00:00:00 for the whole numbers.

I do not want to use IFs or similar approach, I was hoping it could be achieved much more elegant way...

Thanks,

Vlad

Thiago_Justen_ — Wed, 13 Jun 2018 03:55:53 GMT

Hello Vladimir,

About your question, make sure your field is formatted as number. Try this out:

Time(Num#(YourField))

Cheers

vlad_komarov — Wed, 13 Jun 2018 13:43:25 GMT

Thanks, Thiago,

But it did not help much:

Here is my code:

let vStep = 1;

set vTrace = 'The Requested Step value = ' & num($(vStep)) & ' or ' & Time(num#('$(vStep)'), 'hh:mm:ss')

The result:

The Requested Step value = 1 or 00:00:00

Vlad

ezkurdim — Wed, 13 Jun 2018 19:58:31 GMT

Replace Time with Interval !

dwforest — Wed, 13 Jun 2018 21:05:21 GMT

If you put in context your end goal it might help.

time values are < 1, so any whole number will have 0 time.

As shown in Help, 0.375 = 09:00

vlad_komarov — Thu, 14 Jun 2018 02:48:57 GMT

Raymond,

How the !@#!@ I forgot about that function???

Thanks!!

Vlad