Hi,
Please help me!!!!!!.... I want to get the last record of city by date range. Example:
I have this information:
vehicle model | city | DATE |
AAA | A1 | 1/2/2017 |
AAA | A2 | 28/2/2017 |
AAA | A3 | 23/2/2019 |
BBB | B1 | 18/2/2017 |
BBB | B2 | 23/3/2018 |
BBB | B3 | 17/2/2019 |
and when I choose one date, for example 23/3/2018 (rate of dates less or equal to the current selection) the result should be:
DATE 23/3/2018
vehicle model | city |
AAA | A2 |
BBB | B2 |
if i select this DATE 23/2/2019
vehicle model | city |
AAA | A3 |
BBB | B3 |