Times and dates stored as text break formulas
Times and dates stored as text cannot be added, averaged, rounded or converted to proper date formats by formula.
Tier II · Emerging Problems that are still building up.
6 public reports · first reported 27 December 2018 · last reported 8 October 2024
What's going wrong
Users who import logs, timers or payment exports often find that times such as minutes and seconds, or dates written as plain digits, are stored as text.
AI-assisted: written with the help of AI from the reports. The idea report has the full summary.
In the idea report
- The full summary.
- The products the 6 reports are about, and how many came each month.
- Related problems.
No business has been found with this problem yet, so the report has no contacts. All sales are final — no refunds. Pricing.