AnsweredAssumed Answered

End of Month Expiration

Question asked by EricDettrey on Jun 24, 2014
Latest reply on Jun 25, 2014 by philmodjunk

Title

End of Month Expiration

Post

     I'm currently working with FileMaker 6 and FileMaker 13. We are rebuilding our database from 6 to 13. 

     I cannot seem to come up with a calculation for an expiration date that will end at the end of the month in which the completed date occurs. If I have a complete date of 6/4/2013, I need the system to automatically set the expiration date to 6/30/2014; the end of the month in which the completed date occurred. 

     I need am looking for help with a calculation for both version 6 and 13.

     Can anyone help me with this?

     Thanks,

Outcomes