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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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.