AnsweredAssumed Answered

Script for "Destroy by" date

Question asked by RashinAlizadeh on Jul 21, 2011
Latest reply on Jul 27, 2011 by philmodjunk


Script for "Destroy by" date



I am creating a filing system where we enter the information for all the office documents into the FM database. Every file has a different shredding date. For every type of file I have assigned how many years to keep it for (1, 5, 10, permanent).

Based on the document date and how long to keep it for I want to create an automatic script in another field called "destroy by".

script function would be something like: Document Date + how many years (1/5,10) = shredding date

if how many years = "permanent"

then shredding date = "permanent"

how would i write such a script?