I've browsed every forum post about filtering based on environment variables, set/get variables, converting string to date, etc. I have tried: changing the date's format, conversion mask, date locale, timezone getting the variable as a string and then later converting to date using metadata in a Select Values step (I get the same 'couldn't convert string to a date using format ' error). It only runs without error if the 'Type' is set to 'String', but then I get the same error on the filter rows step as I am comparing a string to a date in the filter condition.Д§ 12:20:59 - Get variables.0 - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 05.09.05 by buildguy) : Unexpected errorД§ 12:20:59 - Get variables.0 - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 05.09.05 by buildguy) : .:Д§ 12:20:59 - Get variables.0 - SixMonthDate String(13) : couldn't convert string to a date using format on offset location 0Д§ 12:20:59 - Get variables.0 - $(SixMonthDate)Д§ 12:20:59 - Get variables.0 - at .convertStringToDate(ValueMetaBase.java:943)Д§ 12:20:59 - Get variables.0 - at .getDate(ValueMetaBase.java:2306)Д§ 12:20:59 - Get variables.0 - at .convertData(ValueMetaBase.java:3862)Д§ 12:20:59 - Get variables.0 - at .processRow(GetVariable.java:109)Д§ 12:20:59 - Get variables.0 - at .(RunThread.java:62)Д§ 12:20:59 - Get variables.0 - at (Thread.java:748)Д§ 12:20:59 - Get variables.0 - Caused by: : $(6MonthDate)Д§ 12:20:59 - Get variables.0 - at .convertStringToDate(ValueMetaBase.java:934)Д§ 12:20:59 - Get variables.0. However, when I try to 'Get Variable' in a linked transformation (to later use in a Filter Rows step), I get the below error log (where 'Type' is set to 'Date'. I know this shouldn't be required but as you'll see down below, this variable seems to be treated as a string instead of a date, so I put this in to see if it would solve that issue - it doesn't.ДЄll of the above runs correctly, even a write to log shows the variable written in the correct date format. Select Values: Change metadata of sixMoDate to ensure value type is Date.Calculator: Use new field constant 'minus 6' of value -6, 'Today' from previous step, and calculation step of 'Date A + B Months' to calculate variable sixMoDate = 'Today' + 'minus 6'.Get system info: Name- Today Type- Today 00:00:00.The goal was to then use this variable in a Filter Rows step. To accomplish this so far I have created a variable called 'sixMoDate' using the below steps in Pentaho. I am trying to filter all data in a CSV file for only rows with a date earlier than 6 months ago. If anyone is able to answer this quickly, I would be eternally grateful lol.

Append rows in pentaho data integration