Seven Stars

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 .

 

 

3 REPLIES
Seven Stars

Re: I need to convert string to date format

what is this 42905 means for MDDYY??

 

Can you specify the date format.. 

Seven Stars

Re: I need to convert string to date format

this is the format MDDYY

Seven Stars

Re: I need to convert string to date format

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

In the tMap Output: 

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