Partial date display in formatted collecting event form

Grant · August 14, 2024, 3:23pm

Hi Soraya,

At this time, the date fields do not respond to the precision that they are set to. I’ve added your report to our GitHub issue tracking this request:

github.com/specify/specify7

Allow choosing partial date or full date in the formatter editor

opened 06:29PM - 20 Mar 23 UTC

grantfitzsimmons

1 - Request 2 - Queries 2 - App Resources 2 - Exporting Data

**Reported by:** Soraya at Bern > Hi, > Partial dates are working well in th…e workbench and in the data entry forms, and also they are correctly exported, but they display as full (wrong) dates in the formatted collecting event form: > > ![image](https://github.com/user-attachments/assets/334710b4-72df-447a-a032-e078b9a6097d) > > > I modified the collecting event format in the record formatters app resource by selecting PartialDate from the options, but the partial date is still displayed a full date: > > ![image](https://github.com/user-attachments/assets/c455a623-06b1-430f-a374-390c7803890b) > > > In the field formatters app resource the date elements look like this: > > ![image](https://github.com/user-attachments/assets/9c832323-bb96-4424-8798-666603925e9a) **Requested by:** [Fedor on the Speciforum](https://discourse.specifysoftware.org/t/date-format-in-dwca-export/1104) > We're having issues with the date format of what is exported as DwcA to be fed to GBIF and I cannot find the right place to adjust this. > > GBIF prefers dates to be in the unambiguous format: YYYY-MM-DD > > However, our Specify7 installation exports as: DD/MM/YYYY > > Example dataset: https://www.gbif.org/dataset/58fc397b-eee4-4138-8a5f-50f9dfb00216 > > As a result, the dataset has about half of its collecting event dates set as being invalid: > https://www.gbif.org/occurrence/search?dataset_key=58fc397b-eee4-4138-8a5f-50f9dfb00216&issue=RECORDED_DATE_INVALID > > Example occurrence is the following: > https://www.gbif.org/occurrence/2012932419 > > This has event date delivered as 11/01/1930 which GBIF refuses to parse, because it's ambiguous. > > How can make sure the date format is 1930-01-11 ? --- ### **Issue:** @grantfitzsimmons > Could we do that with a custom formatter for that field? _In the future^_ @maxpatiiuk > I belive it uses the format from remote prefs right now > Formatters in sp7 don't support partial days ### **Solution:** @maxpatiiuk: > The way sp6 fixed this is that it hardcoded some formatters to be for partial date and added Java code to treat those formatters in a special ways > For sp7, we should just allow you to pick partial date or full date in the formatter editor

Thank you for your illustrative screenshots and clear explanation of the issue! This will help our developers better understand the issue.

Topic		Replies	Views
Date displays in the collection record New Feature Requests	2	237	March 1, 2023
Clarification on Date precission fields and their use Get Help	3	82	June 19, 2024
Collecting events disambiguation in workbench Specify 7 Get Help	0	148	February 29, 2024
Work bench mangling dates Get Help	2	247	August 25, 2022
Table Format Editor in Specify 7 Get Help Solved	2	251	July 31, 2023

Partial date display in formatted collecting event form

Related topics