none
Help with calculating expiration date

    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.

    =DateAdd("m",10,Date())

    =DateAdd("y",-1,Date())

    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.

    Thanks

    sNiPel2

    Sunday, March 15, 2015 2:51 AM

Answers