AnsweredAssumed Answered

Date series calculations

Question asked by jayGamel on Oct 24, 2012
Latest reply on Oct 25, 2012 by jayGamel


Date series calculations


     We publish 22 issues of a paper a year, publishing only a Jan 15 and a July 1 and on the 1st and 15th of every other month. I want a calculation that could 

  •           know today's date
  •           increase the issue number by 1
  •           change the day to "1" or "15"
  •           change the year every jan 15

     I'm having no luck whatsoever even getting started on this since dates throw me for a complete loop.


     I have Issue_number, and Issue_date. I suspect it's easier to work with numbers and convert them to a specific date to do this, but  nothing has worked for me.


     Any help gratefully accepted.

     macintel - fmp 11.x