Approximate or incomplete dates

[neilsilberman]

I am working on a historical database in which many birth/death dates are approximate, uncertain, or incomplete. Previously I have used the Library of Congress's EDTF system (Extended Date Time Format (EDTF) Specification (Library of Congress) (loc.gov). Does anyone know how this might be implemented in a Caspio table?

PLEASE NOTE: I had posted this question earlier under the title "Fuzzy Dates," which is an accepted term in history and archives. Someone sent me a warning and I have been penalized for "spamming." I was NOT spamming about romantic dates. I request that the warning and penalty be removed. Thanks!

[Kurumi]

Hi @neilsilberman - do you have sample data or expected results for reference of the dates? In Caspio tables, I believe it only accepts MM/DD/YYYY or mm/dd/yyyy hh:mm:ss format in the table. In the DataPage, you may customize or change its format. For more information, you can check this article: https://howto.caspio.com/datapages/datapage-components/field-formatting-options