DSXchange

I am trying to filter out a specific expiration date. I am currently using a filter stage with a where clause:

Level_Status_Expiration_Date <> '1900-01-01'

I get the following error:

Expiration_Date_Filter: Parse error: Expected 'is' statement ('is true', 'is false') or boolean operator (and, or) got: "-01".

What would the best way to exclude records with this expiration date?

The logic you have should work fine. Double check to make sure you don't have the word 'is' or any extra stuff like that floating around in the Filter stage or in its where clause.

Here is the copied text of what I have in the Where Clause...

So... quoted or not quoted? You've shown it both ways now. I'd also like to know if your "expiration date" field's datatype is a date or a string.

Sorry it is not quoted, and the field's datatype is date. Thanks.

I'm not sure how picky the Filter's where clause conditions are and if it supports direct comparison to a DATE field like that. From looking at the documentation, you may be better off converting that date to a string and then filtering on the resulting string date.

Try enclosing the date constant in single quote characters.

Not sure where the "is" message is coming from. You might consider inspecting the generated OSH, or dumping the job score, to investigate this.

Filtering Date with Quotes (Just like SQL Where Clause) is not giving any Issue: Example: date_1 <> '1900-01-01' (Filtering without Quotes thinks its a Condition and expecting operators)