Hi,

We're building a FMP 6 database that is basically a library catalog of museum artifacts. Our loans system is dependent on dates example: due date=today +14 ; no. of days late= today-due date etc.

If we go into the computer's settings and change the date, it then affects dates of all new loans. For eg. change the computer's date to 1/1/1900 and the due date with be 1/15/1900.

Is there a way for us to "lock" the date system used on the computer so no one else can change it? Or is there a plug-in or file that we can get today's date from, rather than use the computer's settings.

Eventually, we'll be accessing the database over a server.

Please advise if I need to post this elsewhere.

Thanks for any help.

Nicci and Chris

On what platform are you?

We're on Macintosh platform OS 9.1