How to extract the time of a time stamp cell?...

expressions
(Michael) #1

How to extract the time of a time stamp cell?

Is there anyway to extract the time portion of a time stamp field? I’ve tried several expressions with no luck… I would prefer to use this in a virtual column rather than an actual column.

(Aleksi Alkio) #2

Add a formula [TimeStampColumn] into the virtual column and change the column’s type to Time.

(Multi Tech Visions) #3

@praveen I think this has been asked before…

Formula suggestion: TIME([DateTime])

And of course one for date too.

(Michael) #4

@Aleksi_Alkio Thanks Aleksi Translate