Filter stage date condition

kpsita · Post by **kpsita** » 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

anbu · Post by **anbu** » Tue Oct 12, 2010 1:26 pm

If your date is in the format YYYY-MM-DD, then you are fine with your condition in Filter stage.

sridinesh2009 · Post by **sridinesh2009** » Thu Oct 21, 2010 5:50 am

If your source is database...
better you can write a query for fetching records of that range.. from database

chulett · Post by **chulett** » Thu Oct 21, 2010 7:24 am

I don't know if it is "better" or not, but if their requirement is to do it "in job" then as anbu noted (with the caveat regarding their string format) what they are doing is just fine - dashes or no dashes.