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