Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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')
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')