Thanks a bunch for the help so far, I'm within spitting distance, but I'm running into an issue.
I've created a group based on TABLE.LEASE and three formulas, which look like this:
First: Date Difference. This gives me an Absolute value for the various differences. It has to be absolute or Minimum will always return the lowest negative value.
Abs (DateDiff ("d",CurrentDateTime ,{TABLE.DUE_DATE}))
then Date Difference 2 which gives me the minimum absolute value based off of the Lease section of the table. This works perfectly.
minimum (
{@Date Difference},{TABLE.LEASE})
Finally we have this monster, Date Difference 3, which *should* return my Due Date (and does, in 95% of cases... but...)
If DateAdd("d",{@Date Difference 2},CurrentDate)=DateValue({TABLE.DUE_DATE}) then DateValue({TABLE.DUE_DATE}) else
DateAdd("d",-{@Date Difference 2},CurrentDate)
The problem is the Original Add function at the begining is never working as intended, so it always ends up satisfying the Else.
If I can get Difference 3 to work as intended I'll beable to use that formula field as a Selection Formula for the records and get the proper payments listed.
At least thats my intention.