current issue date

[jaygamel]

I need a formula that will find the next higher date on a list from today and return it to a field in a separate table. Table 1=Publication dates, table 2=Subscribers with start issue date. this will let me calculate when reminder letters go out and when to stop mailing.

I've generated a today field the P table and can find current issue through a very clunky lookup process, but I think there's something a lot better out there.

Any help appreciated.

[Søren Dyhr]

The list does indeed benefit from being a table/file, where you then utilize the Lookup Next Higher feature, by adding a date to the primary keyfield.

--sd

[jaygamel]

Thanks, that's pretty much exactly what I did. I was just thinking there was an easier way than creating a "today" field to use to compare to "issue date" to come up with what I want.

essentially, I want:

where today greater than the last issue date and lower than the next issue date, return next issue date

is that doable? without having to create a "today" field?