MS-Access find closest date
Posted on 2012-03-14
Hello experts, I have a tricky problem with trying to find the closest date that I need some help with.
When a user enters a date in a text box, I would like to find the nearest date in a table, the closest future date if available otherwise the closest past date
e.g if the text box value is 29-Feb-2012 then I would like to return the value 02-Mar-2012 from the table [TBL_Dates].[Upload_Date] below.
Thanks for any help