Hi

I have tried the above solutions and the syntax provided. It drew a blank result.

Try this also :

Select b.deliverydate

From ordertable as b

Where to_char (b.deliverydate,’DD-Mon-YYYY’) = ‘16-Nov-2017’...

The format written in the data dictionary DATE. No format stated.

Thanks for answering call of help! The rank over works wonderfully using ASC. The error I found is due to another syntax error within the scripts.