AnsweredAssumed Answered

Script for "Destroy by" date

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

Title

Script for "Destroy by" date

Post

Hi,

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?

Thanks

Outcomes