Common questions about Last Modified Time on Android fall into 3 areas: display format, field differences, and formula use; the answers below cover the most common issues in daily use.
FAQ
Does the Last Modified Time field support a 12-hour clock?
- On Android, this field does not currently provide a direct switch between 12-hour and 24-hour display.
- If you need a different display format, adjust the related time display settings on a desktop device.
- After that, return to the table and review the display result.
What is the difference between the Last Modified Time field and a date field?
- The Last Modified Time field records when a record was edited most recently.
- A date field is more suitable for storing calendar dates and can also show time depending on its settings.
- If you need an automatically updated edit timestamp, use Last Modified Time.
Can the Last Modified Time field be used in formulas?
- Yes. This field can participate in time-based calculations.
- Make sure the formula references the correct time field.
- Then calculate time differences or other time results as needed.
Glossary
| Term | Definition |
|---|---|
| Last Modified Time | A system field that records the most recent edit time for a record automatically. |
| Field Type | The data format definition for a table column, such as date, time, or text. |
| Auto-fill | A value written by the system automatically instead of being entered manually. |
| Time sorting | Sorting records in ascending or descending order by time. |