DSXchange

Hi Folks

I'm passing date in a a preset format to a filter stage from a unix script, this is a constant for a particular day . I am comparing this date with data coming into a Filter . The comparison seems to yield some results that are not consistent . Do i have to use a transformer to compare the dates , or i have to the check th comparison logic in the filter ?

What is the date format?

Ram,
Both the date formats have to be same....

Regards,
Shiva....

Comparison could be >, <, =<, => or even <>. For this very reason, not only they have to be in identical formats, they should be in YYYY-MM-DD or YYYY/MM/DD. In short, any format that first has 4 digit year, 2 digit month and 2 digit day.

Folks thanks for your comments first ! But seems that there is something missing altogether , i tried to parameterise the date passed from a shell script and compare Something like

ROWDATEFIELD > #shellScriptDate#

This is not working at all ! The where clause does not get a boolean parameter to evaluate !

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

05 is the month in the shellScriptDate (YYYY-MM-DD) and MM is 05 !
------------------------------------------------------

Any other stages that can pull this trick off ? Any workarounds for the filter ..

Aint this a Parallel Edition Question? Its in the wrong Forum..