End of Month Expiration
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?