Formatting Datetime

[#1]

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 · Accepted solution]

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')