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

[NenadV]

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]

Hi, @NenadV 

See the solution in the topic below:

https://community.qlik.com/t5/QlikView-App-Dev/Converter-numero-em-data/td-p/759968

Regarts,
Matheus

[NenadV]

thanks Matheus . My case is different.

For example, date 22.12.2023 is stored as 1231222

[NenadV · Accepted solution]

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