The table fieldreport contains amongst other fields, 5 important date fields.
| column
|
used as
|
comment
| | dateofreport |
Date of Information |
Is selected by the user
| | reportreceiveddate |
Data Entry Date |
Is set when the user clicks on the Save button
| | reportcompleteddate |
Submitted Date |
Is set when the user clicks on the Submit button
| | reportverifieddate |
Approved Date |
Is set when the user clicks on the Approve button or when the report is automatically approved at import
| | dataentrydate |
Last updated |
Is changed when e.g. the template is switched
|
|