Can I get the value closest to a specific date?
I wonder if it's possible to fetch a value from a table that is closest to a specific date. An example is that you want to fetch the value of 31 of May. This date does not exist instead I want to get the closest value to the 31 of May. It doesn't matter if it's an earlier date or later just the closest. Between doesn't work since I only have one date and I just want to get another date.