Comparing 2 dates in a Filter stage

ag_ram · Post by **ag_ram** » Tue Apr 24, 2007 9:27 am

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 ?

DSguru2B · Post by **DSguru2B** » Tue Apr 24, 2007 10:36 am

What is the date format?

vipshiva · Post by **vipshiva** » Wed Apr 25, 2007 4:11 am

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

Regards,
Shiva....

DSguru2B · Post by **DSguru2B** » Wed Apr 25, 2007 7:17 am

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.

ag_ram · Post by **ag_ram** » Wed Apr 25, 2007 10:40 am

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 ..

DeepakCorning · Post by **DeepakCorning** » Wed Apr 25, 2007 10:48 am

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