This question is related to http://www.experts-exchange.com/Q_23476744.html
I have a dilemma.
I have a table with 2 fields
[ Date ] [ Value]
I want to obtain the percentage change over 1 month from the last date (which is June 11). But 1 month ago, May 11 is a Sunday, so there is no data on that date.
How can I select a date immediately prior to May 11 if there is no data for that date, and one more day prior if there is still no data for that date either?