Time out timestamp

[#1]

I would like to get the time out of my timestamp field.

in the format: HH:MM:SS

I can get the date out of it with the next expression:

=Date(Floor(emptyings_date_time))

Now I need the time part

In addition, I would also want to calculate the differece between each time out of the timestamp.

[kaushiknsolanki]

Hi,

Try this.

     Time (emptyings_date_time - Date(Floor(emptyings_date_time)))

Regards,

Kaushik Solanki

[#3]

That doesn't work.

I can't get the time out of the timestamp with: time(emptyings_date_time)

Is there an other way to get the time?

[kaushiknsolanki]

Hi,

     That may be because the Emptyings_date_time field wont be in date format.

     You first convert it into Timestamp and then use the Time(Field) to get the time.

     You can use the expression which I have given in earlier post to just get time.

Regards,

Kaushik Solanki   

[#5]

How do I convert this field?

It looks like a timestamp and the date() function does work with it

[kaushiknsolanki]

Hi,

     If date works then time should also work.

     Can you tell me what expression you are using.

     And when you used the only I told you, what output you got?

Regards,

Kaushik Solanki

[Anonymous]

Hi,

Try below,

Maketime(Hour(emptyings_date_time), Minute(emptyings_date_time),Second(emptyings_date_time))

[#8]

For the date I used:

=Date(Floor(emptyings_date_time))

If I use: Date(emptyings_date_time)

it doesn't work. So i think I need to add something like 'floor' to the time expression?

For the time I tried:

=Time(emptyings_date_time)

With the result:  -

Your expression had the result: -

[#9]

Doesn't work unfortunatly

I only get: -

[kaushiknsolanki]

Hi,

     can you post your application with some sample data which replicates this issue.

Regards,

Kaushik Solanki