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]

[soniasweety]

my field format is like this   below that's why I used num in variable

42860.08154

42860.13194

42860.16713

42860.19242

42860.20373

42860.20534

42862.93403

[sunny_talwar]

Try this

LET vToday = Num(Now())

and then this:

Interval(If([Timestamp Num] > $(vToday), (Fabs($(vToday) - [Timestamp Num]))), 'hh:mm:ss')

[soniasweety]

Nothing same null,

but variable is working in text object sunny

but  expression is not working

[soniasweety]

field is calucalted like this

Timestamp#(Date(RDDate)&' '&Time(RDTime,'hh:mm:ss'),'MM/DD/YYYY hh:mm:ss')

[sunny_talwar]

Would you be able to share a sample?

[soniasweety · Accepted solution]

working this sunny

if([Timestamp Num]> $(vToday), Interval(Fabs($(vToday) - [Timestamp Num]),'hhh:mm:ss'))

[sunny_talwar]

With three h? or is that a typo

[soniasweety]

yes its working fine enough

[sunny_talwar]

Okay, but I think it should work with two h also (and probably the right syntax even though 3 h works)

if([Timestamp Num]> $(vToday), Interval(Fabs($(vToday) - [Timestamp Num]),'hh:mm:ss'))