Convert text to date

Omeka S
1

I’ve used this field in text format dcterms:created to enter the dates of my documents in DD/MM/YYYY format.
Is there a procedure for changing this field to date format YYYY-MM-DD?
Thanks in advance

2

If you’ve already uploaded the data into Omeka S, there isn’t really a way to automatically convert it – see Numeric Data Types - Omeka S User Manual on what the “Convert to numeric” function can and can’t do if you’ve installed the “Numeric Data Types” module. If you can download your data in a CSV spreadsheet, using the Excel formula =TEXT(A2,"yyyy-mm-dd"), where A2 is the cell that contains your info in “DD/MM/YYYY” format, will change the date information to “YYYY-MM-DD” format.

3

the “Convert to numeric” function of module “Numeric Data Types” doesn’t work and has no effect in the value table for the type field, which remains literal instead of numeric:timestamp