topic Re: Business Rule for Dates in Talend Studio

Business Rule for Dates

Anonymous — Sat, 16 Nov 2024 04:37:37 GMT

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

Re: Business Rule for Dates

TRF — Thu, 19 Sep 2019 15:12:30 GMT

To be sure, give an example of the input date you want to convert

Re: Business Rule for Dates

Anonymous — Thu, 19 Sep 2019 15:18:24 GMT

Here's the input format:

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

Thank you