Hi All,
I’ve researched this but could not find anything suitable so i’m here to beg for your help!
This might be a simple thing but it has got be stumped.
So here’s the scenario....
I have a table with a list of dates [PaymentRun] and a query which basically calculates [due date]. What I would like to do is to compare the [due date] to the [PaymentRun] and return the value which is the closest date in the future.
i.e.
table 1
17/05/2018
26/05/2018
if [Due Date] = 18/05/2018 then 26/05/18 is returned.
Hope this make sense about would appreciate any feedback.
Many thanks
I’ve researched this but could not find anything suitable so i’m here to beg for your help!
This might be a simple thing but it has got be stumped.
So here’s the scenario....
I have a table with a list of dates [PaymentRun] and a query which basically calculates [due date]. What I would like to do is to compare the [due date] to the [PaymentRun] and return the value which is the closest date in the future.
i.e.
table 1
17/05/2018
26/05/2018
if [Due Date] = 18/05/2018 then 26/05/18 is returned.
Hope this make sense about would appreciate any feedback.
Many thanks