Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
mario-sarkis
Creator II
Creator II

date form

Hey all

any idea if I want to Transfrom

number to date form example :

"42467" should look like this : "20160407".

Thank you,

2 Replies
rahulpawarb
Specialist III
Specialist III

Hello Mario,

Please use below:

=Date(42467, 'YYYYMMDD')

Hope this will be of help.

Regards!

Rahul

qlikviewnovice
Specialist II
Specialist II

Hi,

=Date(42467,'which ever date format you want')