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 ?
Comparing 2 dates in a Filter stage
Moderators: chulett, rschirm, roy
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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
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 ..
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 ..
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am