Help with calculating expiration date RRS feed

  • Question

  • Hi Microsoft Access community.

    I am trying to automatically set the expiration date in my table each time new data is entered which is +10 months -1 Day. My field name is called 'Best Before Date:', Data Type is called Date/Time, Format is set to 'Short Date' and under the Default Value field property I have two expressions I am trying to input.



    These expressions work for me only when they are input separately. My issue is that I want to combine these two expressions but I don't know how.

    If anyone has any ideas of how to accomplish this task best please do help.



    Sunday, March 15, 2015 2:51 AM