Filter stage date condition
Posted: Tue Oct 12, 2010 1:22 pm
Hi,
I have a requirement where DATE_FIELD is between Date1 and Date2. For this I am using the following function in filter stage.
DATE_FIELD >= Date1 AND DATE_FIELD <= Date2
All my fields are from database with Data (10) in the format YYYY-MM-DD. I wanted to know if the function used in FILTER stage is correct, or should I use transformer to first convert into YYYYMMDD and then use contraint to check the condition.
i tested and looks like working fine with the filter stage, but wnated to make sure if the function used is correct.
thanks
I have a requirement where DATE_FIELD is between Date1 and Date2. For this I am using the following function in filter stage.
DATE_FIELD >= Date1 AND DATE_FIELD <= Date2
All my fields are from database with Data (10) in the format YYYY-MM-DD. I wanted to know if the function used in FILTER stage is correct, or should I use transformer to first convert into YYYYMMDD and then use contraint to check the condition.
i tested and looks like working fine with the filter stage, but wnated to make sure if the function used is correct.
thanks