Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
tanjavarwijk
Contributor III
Contributor III

How to convert into 2 fields date and time

8/11/12 11:51:56 AM
8/9/12 11:17:06 AM
8/17/12 12:59:30 PM

I tried timestamp#( ,'DD/MM/YYYY hh:mm:ss')

I tried date#(  ,'DD/MM/YYYY')

1 Reply
rajni_batra
Specialist
Specialist

use date#(8/11/12 11:51:56 AM,'DD/MM/YY')

time#(8/11/12 11:51:56 AM,'hh:mm:ss')