topic Re: Separate time from date in QlikView

Separate time from date

cscherer — Tue, 14 Aug 2012 14:38:45 GMT

Hello,

I want to separate a field which is in this form:

11.01.2012 09:53

into two fields:

date:

11.01.2012

time:

09:53

I tried time() and makedate(), but they don`t work.

Could you please help me?

Thank you in advance,

Clemens

Anonymous — Tue, 14 Aug 2012 14:42:39 GMT

use date(field)-it will give u the date

use time(field) - gives u the time

cscherer — Tue, 14 Aug 2012 14:48:34 GMT

Hello,

thx, but this doesn`t work.

I tried left(date, 10), this seems to work.

thx for your help

reg,

Sun, 10 Feb 2013 13:28:06 GMT

To remove the time and preserve as a date field, assuming your field is called InputDate, use:

Date(Floor(InputDate))

To get just the time, use:

Time(InputDate)

cscherer — Fri, 05 Apr 2013 11:35:55 GMT

thanks for the answer, i`ll try it!