topic Re: Show date time in two separate columns in Archived Groups

Show date time in two separate columns

bhavvibudagam — Wed, 23 Jul 2025 14:48:52 GMT

Hi,

Can any one please help me.

I have one date filed in the format of '23/08/2016 06:55:60 PM' I want to display this Date in two separate columns i.e Date contains 23/08/2016 in one column and Time contains 06:55:60 PM in another column in script.

Re: Show date time in two separate columns

marcus_sommer — Fri, 04 Mar 2016 13:59:12 GMT

You could do it with:

date(floor(YourTimestamp)) as date,

time(frac(YourTimestamp)) as time

...

and please choose the next time another community area maybe New to QlikView - then this isn't a bug.

- Marcus

Re: Show date time in two separate columns

oknotsen — Mon, 28 Mar 2016 10:29:05 GMT

This is not a bug.

Topic started multiple times. Other topic here:

Show date time in two separate columns

Topic locked. Warning send.