duursma opened a new issue, #3051: URL: https://github.com/apache/hop/issues/3051
### Apache Hop version? 2.5 ### Java version? openjdk version "19.0.1" 2022-10-18 ### Operating system Windows ### What happened? I want to test a date field against a date constant in the "Filter Rows" component. For this you have to provide a string and a format. But it seems the String is saved as a date in an internal format and the verified against the supplied format on testing. And those two don't necessarily match. Test case a data grid with a date field. And a filter rows component with to dummy's as exits. Test against a date with a yyyy-MM-dd format. 2023/07/03 16:15:22 - Filter rows.0 - ERROR: Unexpected error found in evaluation function : 2023/07/03 16:15:22 - Filter rows.0 - ERROR: Error occurred for row: [01-01-2023] 2023/07/03 16:15:22 - Filter rows.0 - ERROR: java.lang.RuntimeException: Unexpected error evaluation condition [ date < [2022/01/01 00:00:00.000] 2023/07/03 16:15:22 - Filter rows.0 - ] 2023/07/03 16:15:22 - Filter rows.0 - at org.apache.hop.core.Condition.evaluate(Condition.java:565) 2023/07/03 16:15:22 - Filter rows.0 - at org.apache.hop.pipeline.transforms.filterrows.FilterRows.keepRow(FilterRows.java:51) 2023/07/03 16:15:22 - Filter rows.0 - at org.apache.hop.pipeline.transforms.filterrows.FilterRows.processRow(FilterRows.java:122) 2023/07/03 16:15:22 - Filter rows.0 - at org.apache.hop.pipeline.transform.RunThread.run(RunThread.java:55) 2023/07/03 16:15:22 - Filter rows.0 - at java.base/java.lang.Thread.run(Thread.java:834) 2023/07/03 16:15:22 - Filter rows.0 - Caused by: org.apache.hop.core.exception.HopValueException: 2023/07/03 16:15:22 - Filter rows.0 - constant String : couldn't convert string [2022/01/01 00:00:00.000] to a date using format [yyyy-MM-dd] on offset location 4 2023/07/03 16:15:22 - Filter rows.0 - 2022/01/01 00:00:00.000 2023/07/03 16:15:22 - Filter rows.0 - 2023/07/03 16:15:22 - Filter rows.0 - at org.apache.hop.core.row.value.ValueMetaBase.convertStringToDate(ValueMetaBase.java:1082) 2023/07/03 16:15:22 - Filter rows.0 - at org.apache.hop.core.row.value.ValueMetaBase.getDate(ValueMetaBase.java:2578) 2023/07/03 16:15:22 - Filter rows.0 - at org.apache.hop.core.row.value.ValueMetaBase.convertDataUsingConversionMetaData(ValueMetaBase.java:4246) 2023/07/03 16:15:22 - Filter rows.0 - at org.apache.hop.core.Condition$CValue.createValueData(Condition.java:917) 2023/07/03 16:15:22 - Filter rows.0 - at org.apache.hop.core.Condition.evaluate(Condition.java:404) 2023/07/03 16:15:22 - Filter rows.0 - ... 4 more 2023/07/03 16:15:22 - Filter rows.0 - Caused by: java.text.ParseException: 2022/01/01 00:00:00.000 2023/07/03 16:15:22 - Filter rows.0 - at org.apache.hop.core.row.value.ValueMetaBase.convertStringToDate(ValueMetaBase.java:1065) 2023/07/03 16:15:22 - Filter rows.0 - ... 8 more ### Issue Priority Priority: 3 ### Issue Component Component: Hop Run -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
