Using Row Number and Partition by to sort records

[lisab80]

I am reading in data from a qvd and I would only like to read in the data where the Wait_Date is the closest to the sunday of that current week and ignore all other dates within that same week - as there may be multiple Wait_Date within a week.  Week is Mon - Sunday.

Example

Wait_Date

03/05/2018

06/05/2018 - correct date to read in

07/05/2018

09/05/2018

11/05/2018 - correct date to read in

Any help greatly appreciated

Thanks

[lisab80]

Hi Marcus

That worked perfect - thank you very much for your help - I was really stuck on that problem

Lisa