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: 
BNP
Contributor
Contributor

Date to string and String to Date

Hi Team,

 

I'm new to this talend tool.can you help this

I have data in Date Column like "DD - MM-YYYY"(16-08-2012) and "DD- Sep-YY"(16-Sep-2012)  in CSV file.

How need to convert String tmap

 

Thanks in advance

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable

Hi
convert string to Date:
TalendDate.parseDateLocale("dd-MMM-yyyy",row1.columnName,"en");

convert Date to string:
TalendDate.formatDateLocale("dd-MMM-yyyy",row1.columnName,"en")

Please try and let me know if you have any questions.
Regards
Shong

View solution in original post

1 Reply
Anonymous
Not applicable

Hi
convert string to Date:
TalendDate.parseDateLocale("dd-MMM-yyyy",row1.columnName,"en");

convert Date to string:
TalendDate.formatDateLocale("dd-MMM-yyyy",row1.columnName,"en")

Please try and let me know if you have any questions.
Regards
Shong