topic Extract only Time from column in App Development

Extract only Time from column

P_Kale — Tue, 26 Dec 2023 13:34:18 GMT

Hi,

I have a column which have date & time in 1 column. I have manage to separate date from this but how i can separate time in another column. Below given is the eg.

INTERACTIONCREATEDAT

2022-03-02 18:53:50.000

I want time i.e. 18:53 only in another column ( Not want seconds). How I achieve this.

Thanks in advance.

Re: Extract only Time from column

MatheusC — Tue, 26 Dec 2023 14:47:25 GMT

@P_Kale

try,

Time(Interaction, 'hh:mm')
Att, Matheus

Re: Extract only Time from column

Anil_Babu_Samineni — Tue, 26 Dec 2023 14:07:32 GMT

I agree @MatheusC , but sometimes it must be like below due to format.

Time(TimeStamp#(Interaction), 'hh:mm') as Interaction_New

Re: Extract only Time from column

rwunderlich — Tue, 26 Dec 2023 15:31:17 GMT

Time(Interaction, 'hh:mm')

will still include the date in the internal value. That may make for peculiar sorting. Iff you want just the time portion, I would recommend

Time(Frac(Interaction), 'hh:mm')

-Rob

Re: Extract only Time from column

P_Kale — Wed, 27 Dec 2023 07:02:47 GMT

Thanks for help.

Re: Extract only Time from column

P_Kale — Wed, 27 Dec 2023 07:03:52 GMT

Thanks for help