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

[vlad_komarov]

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_]

Hello Vladimir,

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

Time(Num#(YourField))

Cheers

[vlad_komarov]

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 · Accepted solution]

Replace Time with Interval !

[dwforest]

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]

Raymond,

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

Thanks!!

Vlad