I have a filemaker 12 database with a layout called report. I can generate a date calculated as get(CurrentDate) without the option of "Do not store calculation results -- recalculate when needed", which will give me the date the report record is created. But the report needs to be filled in by someone else and there is a Yes/No field at the end of the report for the person who filled in the report to mark whether the report is ready to be released. I want to record the date when the person actually fills in the report instead of letting the person enter the actual date for the purpose of efficiency and accuracy too.
My question is how do I capture the date when the person fills in the report? If I use un-strored Get(CurrentDate), the date will be updated everytime the record is accessed, right?
Thanks a lot for your help!