How can I select records that have latest date before today?
For example, I have multiple records with dates of two days ago (eg. 2017-07-10). then I have more records with other dates (eg. 2017-07-09, 2017-07-08...).

Now I want to select all the records with date 2017-07-10. I don't want other dates like 09, 08, 07. Only select latest date before today. How can I do that?

```
SELECT
    AR.ID, mR.Description, AR.ActualReading 
FROM 
    machines M 
    INNER JOIN machinemeterreadinglist mRM 
        ON mRM.MachineID = M.ID 
    INNER JOIN meterreadingdescription mR 
        ON mR.ID = mRM.MeterReadingID 
    INNER JOIN actualmeterreading AR 
        ON AR.MachineMeterReadingId = mRM.ID 
    INNER JOIN meterreadingrecords mRec 
        ON mRec.ActualMeterReadingID = AR.ID 
WHERE 
    M.ID = '4364616d-8cff-4507-9dae-be4be8aee1f5' 
    AND mRec.rDate < CURRENT_DATE() 
LIMIT 
    1 ;

```