hello

sorry i should have been clear .

yes currently thats what i have in place and trying to aviod hard coded dates

like "where trunc(order_created_date ) between '01-JAN-2010' and '31-JAN-2010'

then i have to change every month mnaually and i do not want sysdate -30 which still forces manual entry to change based on the month to i am trying to skip that too

so my cron runs on feburary 1st and gets all january data and when it runs on march first it gets all february data and so on..

thanks for your help