Lookup - By Two Fields and Sorting by Earlier Dates

Lookup - By Two Fields and Sorting by Earlier Dates

I have this lookup.  It works except for I can't find a way to ensure I get the date that is previous to the current date.

tlRecord = Daily_Water_Gauges[Lease_Name = input.Lease_Name && Meter = input.Meter] sort by Water_Gauge_DateTime desc;
input.Previous_Water_Gauge_DateTime = tlRecord.Water_Gauge_DateTime;
input.Previous_Meter_Reading = tlRecord.Meter_Reading;

Any suggestions?