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
