Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Vinni2000
Contributor III
Contributor III

Date format change

I have date field like this 20220728 (YYYY MM DD) and time field like this 220214 (hhmmss) so now I want convert date time into time stamp format like this DD/MM/YYYY hh:mm:ss

Labels (1)
2 Replies
hic
Former Employee
Former Employee

Timestamp(Date#(DateField,'YYYYMMDD')+Time#(TimeField,'hhmmss'),'DD/MM/YYYY hh:mm:ss')

Kushal_Chawda

@Vinni2000  one more option

=timestamp(Timestamp#(Date&Time,'YYYYMMDDhhmmss'),'DD/MM/YYYY hh:mm:ss')