AnsweredAssumed Answered

Date series calculations

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

Title

Date series calculations

Post

     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

Outcomes