Skip to Content
0
Former Member
Apr 26, 2007 at 10:32 AM

Current Issue..

10 Views

Post Author: simon82

CA Forum: Formula

Hello,

I am currently trying to figure out a way to show the current issue of a magazine a team is working on.

These dates will run in weekly increments. The issue just gone was 26/04/2007 so i wish to get 03/04/2007 as the "Current Issue" then when this issue passes move onto 10/04/2007.

II have a field that is populated with the date and is therefore not null when an issue passes so can use this to recognise when the date should move on.

basically, an advert could be booked for

26/04,03/05,10/05,17/05 etc...

What the user wants to see is customers booked into the current issue who are not booked into all issues remaining in the year.

If this was one discreet date ift would be fine as i could take the min date but this needs to be more dynamic.

any help please?