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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.