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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
RAJ6
Contributor III
Contributor III
‎2017-10-04 08:40 AM

I need to convert string to date format

Hi Folks,

 

  • When I import my excel in talend
  • My date column datatype is string.
  • My date column value is there in this format (42905).
  • Please help me how to convert this number to date .

 

 

Labels (2)
Labels
218 Views
0 Likes
3 Replies
ashif2
Creator II
Creator II
‎2017-10-04 09:07 AM

what is this 42905 means for MDDYY??

 

Can you specify the date format.. 

218 Views
0 Likes
RAJ6
Contributor III
Contributor III
‎2017-10-04 10:25 AM
Author

this is the format MDDYY

218 Views
0 Likes
ashif2
Creator II
Creator II
‎2017-10-04 10:46 AM

Add Variable Port  named:
FormatDate  = row2.Dated.length()==5?"0"+row2.Dated:row2.Dated 

In the tMap Output: 

TalendDate.parseDate("MMDDYY",Var.FormatDate) 

218 Views
0 Likes