Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
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
Champion II
Champion II

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