Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Business Rule for Dates

Hello,

 

I'm trying to establish a business rule for a date that I've introduced with string format. I want the output to be a Date with the next format: dd/MM/yyy, and the null values to remain null. I've tried this one that doesn't work:

 

TalendDate.isDate(row1.Fecha_de_Llegada_Real,"EEE MMM dd HH:mm:ss zzzz yyyy") ? TalendDate.parseDate("dd/MM/yyyy",row1.Fecha_de_Llegada_Real) : null

 

Could anyone help me?

 

Thank you!!

Marc

 

 

Labels (3)
2 Replies
TRF
Creator III
Creator III

To be sure, give an example of the input date you want to convert
Anonymous
Not applicable
Author

Here's the input format:

 

0683p000009M7Q1.png

 

But when we define it as a string in TOS, It changes to another format.

 

Thank you