Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
SMahadevan1608028474
Contributor
Contributor

Convert Integer to Date format

my source file has DOB column which is Integer datatype

Eg: 20210103 (YYYYMMDD) format

using tMap the same column I would like to get in output table as Date format (YYYYMMDD).

How to convert Integer to Date format value?

Labels (2)
1 Reply
CLi1594691515
Contributor
Contributor

First you need to parse 20210103 to String (if you are using Integer)

Then, use TalendDate.parseDate to parse it to date.

*it will return "null" if using String.valueOf(<value>) , if the value is empty.