Hi Fletch/TedPride, Thank you for the update ..BUT I am not sure if this gets all the records for the last 45 days. I did try the code you pasted...but its not showing all the records for the last 45 days Is there any other way of doing this in either perl or unix.