topic Re: Formatting Datetime in QlikView

Formatting Datetime

Tue, 14 Jul 2015 20:26:28 GMT

Hi masters..

I am really new in qlik.

Iwould like to split( separate ) the date and time in diferent columns with no success.

Thats the Datetime ( it comes from sql server):
01-07-2015 10:08:2015

Thanks.

sunny_talwar — Tue, 14 Jul 2015 20:32:36 GMT

Try this:

Date: =Date(TimeStamp#(Left('01-07-2015 10:08:2015', 19), 'DD-MM-YYYY hh:mm:ss'),'DD-MM-YYYY')

Time: =Time(TimeStamp#(Left('01-07-2015 10:08:2015', 19), 'DD-MM-YYYY hh:mm:ss'),'hh:mm:ss')

Edit: In script:

Date(TimeStamp#(Left(Datetime, 19), 'DD-MM-YYYY hh:mm:ss'),'DD-MM-YYYY') as Date,

Time(TimeStamp#(Left(Datetime, 19), 'DD-MM-YYYY hh:mm:ss'),'hh:mm:ss')