topic What is the easiest way to transform date stored as integer into the qlik date format? in App Development

What is the easiest way to transform date stored as integer into the qlik date format?

NenadV — Mon, 22 Jan 2024 17:39:34 GMT

In the source DB dates are stored as integers where the year 1 is 1900 and the format is the following : YYYMMDD (e.g. 1231231= 31.12.2023)

Thanks

MatheusC — Mon, 22 Jan 2024 18:09:45 GMT

NenadV — Mon, 22 Jan 2024 18:19:16 GMT

thanks Matheus . My case is different.

For example, date 22.12.2023 is stored as 1231222

NenadV — Tue, 23 Jan 2024 07:55:47 GMT

I've found it myself. In SQL select statement I've used this

convert(date, concat('20', substring(str(DTIN65),5,2), substring(str(DTIN65),7,2), right(str(DTIN65),2))) tmpInvdate

and then in the load section this:

date(date#(tmpInvDate, 'YYYY-MM-DD')) as InvDate