topic Re: [resolved] tFilterRow - can not filter on dates in Talend Studio

[resolved] tFilterRow - can not filter on dates

Anonymous — Sat, 16 Nov 2024 13:38:49 GMT

Hi there,
Trying to filter on a date column in v.3.2.1 but it fails with error
-- The method compareTo(Date) in the type Date is not applicable for the arguments (int)

These are my comparasions
sl_date >= 01/01/2004
sl_date <= 01/31/2004
date format is "MM/dd/yyyy".

Re: [resolved] tFilterRow - can not filter on dates

Anonymous — Wed, 16 Dec 2009 10:54:04 GMT

Hello,
Instead of 01/01/2004 String for your comparaison, can you try with TalendDate.parseDate("MM/dd/yyyy","01/01/2004")) ?
Regards,
SeB

Re: [resolved] tFilterRow - can not filter on dates

Anonymous — Wed, 16 Dec 2009 17:27:51 GMT

Hello,
Instead of 01/01/2004 String for your comparaison, can you try with ?
Regards,
SeB

Hi samlleret, thank for reply.
I did put TalendDate.parseDate("MM/dd/yyyy","01/01/2004")) in Value field so my filter looks like this now
sl_date <= TalendDate.parseDate("MM/dd/yyyy","01/01/2002"))

but I got error message
Syntax Error on token "&&", Expression expected after job ImportSalesData

Re: [resolved] tFilterRow - can not filter on dates

Anonymous — Thu, 17 Dec 2009 08:40:57 GMT

Hello

sl_date <= TalendDate.parseDate("MM/dd/yyyy","01/01/2002"))

but I got error message
Syntax Error on token "&&", Expression expected after job ImportSalesData

The correct expression is:

sl_date <= TalendDate.parseDate("MM/dd/yyyy","01/01/2002")

Best regards
shong

Re: [resolved] tFilterRow - can not filter on dates

Anonymous — Thu, 17 Dec 2009 10:29:18 GMT

Thank shong and sorry for my mistake in my copy and paste 😉

Re: [resolved] tFilterRow - can not filter on dates

Anonymous — Thu, 17 Dec 2009 17:49:49 GMT

Well, I am getting error on tInformixInput now.
-- SQLException: Unable to build a date Object based on localized date stream representation.
I derived schema out of real table and I am not sure why it fails. "Date Pattern" "MM/dd/yyyy" was default one chosen by schema builder.

Re: [resolved] tFilterRow - can not filter on dates

Anonymous — Thu, 17 Dec 2009 20:51:34 GMT

After fixing schema issues this line worked just fine
sl_date <= TalendDate.parseDate("MM/dd/yyyy","01/01/2002")

Thanks

Re: [resolved] tFilterRow - can not filter on dates

_AnonymousUser — Tue, 03 Jun 2014 09:08:06 GMT

I have tried below formula in tMAP, but get an expression error message.
row1.DATUM >= TalendDate.parseDate("yyyy-MM-dd","2010-01-01")
What might cause the error?

Re: [resolved] tFilterRow - can not filter on dates

Anonymous — Tue, 03 Jun 2014 09:24:59 GMT

What is datatype of row1.DATUM?
You can't compare date like this in talend....
Check following post
https://community.talend.com/t5/Design-and-Development/Date-comparison-in-Tmap-fails/td-p/80901
Vaibhav

Re: [resolved] tFilterRow - can not filter on dates

Anonymous — Tue, 23 Oct 2018 22:57:47 GMT

Hi how can i filter one date field to today's date.
Can you please show using tmap and tfilter row both
.
Scenario is like:
Input file excel.
Date column in MM/dd/yyyy format

Re: [resolved] tFilterRow - can not filter on dates

Anonymous — Tue, 23 Oct 2018 23:00:09 GMT

How can i filer a date to today'swhich is in format MM/dd/yyyy.