ORDER BY last editing Date/Time
It would be nice, if it becomes possible to order the data entries by the Date of the last editing.
Would be nice to be realized in the adroid app and the Windows GUI...
3
votes

-
Douglas Johnson commented
Add a calculation field with the function "FormatDateTime(now()) "
You can just type it in. The function "now()" requires no parameters.
Each time you open the record for editing, whether or not you make changes, the field contents will be changed to the current date and time.
Choose how you want this displayed - if you want it as a status displayed in list view I recommend choosing string.