Just a guess given the lack of detail, but '01-JULY-02' should probably be '01-JUL-02' - did you check any errors returned from your DBI calls? (presuming, of course, that DBI is the Database Interface that you're using)

rdfield