You are right PAVB...my table is range partition on date field.
Thanks...