Looking at adding a date field to a document. having a little problem.
The idea is to use the date as part of a serial number, first part is user, second part is date and third part is a number.
The user is easy i can pull that from the machine, third part is user defined.
Problem is the date, all the functions i can think of would keep changing the date which is not what is wanted. The first time the finished document is saved, that is the date i want. As this is a template the creation date is irrelevant, a modification date would change if someone opened the file, so is there another way?