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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers