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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
RAJ6
Contributor III
Contributor III

Date format issue

Hi Folks,

 

             How to convert below date format to normal date. Kindly share your information.

  INPUT                                        

Thu Apr 30 00:00:00 UTC 2015 

 

OUTPUT

30-03-2015

Labels (2)
2 Replies
Anonymous
Not applicable

Hi,

 

You can simply use the "TalendDate.formatDate("yyyy-MM-dd HH:mm:ss",myDate)" function.

You will get a String and can get a Date with the TalendDate.parseDate() function :

 

TalendDate.parseDate("yyyy-MM-dd HH:mm:ss",TalendDate.formatDate("yyyy-MM-dd HH:mm:ss",row2.MyDate),true)

Anonymous
Not applicable

Hi,

Here it's the pattern

EEE MMM dd HH:mm:ss zzz yyyy

 

It's working for you ?

 

SGV