Date format

[Vinni2000]

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

[rwunderlich]

Date numbers are integers and Time numbers are fractions of day. Make sure both values are interpreted to numbers and add them together. 

TimeStamp(
Date#('20220728', 'YYYYMMDD') + Time#('220214', 'hhmmss')
, 'DD/MM/YYYY hh:mm:ss')

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com