correct format

[soniasweety]

Hi all,

I want to set it to  timestamp format like   hh:mm:ss  how can I achieve this?

usning this :

if([Timestamp Num]> $(vToday), (Fabs($(vToday) - [Timestamp Num])))

variable -vToday:   =num(Timestamp(Now(),'MM/DD/YYYY hh:mm:ss'))

current output:  0.07 ,0.10  like that

required output:  01:20:01    like this [its example output]

[felipedl]

Hi Sony,

Your variable vToday is formating the timestamp as a number with num().

Try taking it out and see the result.

Felipe.

[sunny_talwar]

Do you need the current time?

LET vToday = Time(Frac(Now()), 'hh:mm:ss');

[soniasweety]

after removing it is giving null 

[soniasweety]

no sunny its giving null

[sunny_talwar]

It is giving null? that can't be true.... I tried and it is working well

[felipedl]

Hi sony,

Putting the formula into a text box:

=Timestamp(Now(),'hh:mm:ss')

gives the following !

[felipedl]

It's probably giving null because his condition for

if([Timestamp Num]> $(vToday), (Fabs($(vToday) - [Timestamp Num])))

isn't met.

[sunny_talwar]

Oh I see... I guess this will now need to use a single quote around the variable

if([Timestamp Num]> '$(vToday)', (Fabs('$(vToday)' - [Timestamp Num])))

[soniasweety]

this also no luck I don't know why