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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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.