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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
lalitkgehlot89
Partner - Creator II
Partner - Creator II

Logic help to create date & Time.

Hi, below given data in text format. I want to convert it into Timestamp (DD-MM-YYYY hh:mm:ss) format.

Please help to convert it.

 

2018/5/30  0:0:0
2018/5/30  0:10:0
2018/05/30  0:10:0
2018/12/30  0:10:0
2018/1/3  0:10:0
2018/1/3  10:10:15
2018/1/23  10:10:15
2018/10/23  10:10:15
10 Replies
Anonymous
Not applicable

Hi,

Just try Following script,

Timestamp(MakeDate(Year(Date#(SubField(Dates,'/',1),'YYYY')),Month(Date#(SubField(Dates,'/',2),'MM')),KeepChar (Subfield(SubField(Dates,' ',1),'/',3),'0123'))&' '& MakeTime( hour( SubField(Dates,' ',2)),Minute( SubField(Dates,' ',2)),Second( SubField(Dates,' ',2)))) as TimeStamp

My result is as follow

table.PNG

May this will help you