Is it possible your data has only the one date to work with?
Do a select distinct shipdate from table_name where rownum < 5 (the rownum < 5 is to limit the output - just need to see if there is more than one date in your table).