# Partial Date options **URL:** \ **Category:** Get Help\ **Created:** [August 22, 2023, 10:22am UTC](https://speciforum.org/t/partial-date-options/1278 "2023-08-22T10:22:37Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![sorosoro](https://avatars.discourse-cdn.com/v4/letter/s/5f9b8f/32.png) [@sorosoro](https://speciforum.org/u/sorosoro)\ **Post date:** [August 22, 2023, 10:22am UTC](https://speciforum.org/t/partial-date-options/1278/1 "2023-08-22T10:22:37Z")
Hi, I have all sorts of partial Dates: Year, Mon / Year but also Day / Mon and even Mon. The last two formats cannot be accommodated by the DatePrecision selection field, so I would have to enter them in the verbatimDate field. That’s not a big problem, but it would be good to have all dates (partial and full) in the same field. Is it possible to add Day / Mon and Mon to the DatePrecision options? If so, would dates with those formats be stored in the database as DD/MM/1900 and 01/MM/1900? Thanks, Soraya ---
**Author:** ![NielsKlazenga](https://avatars.discourse-cdn.com/v4/letter/n/47e85d/32.png) [@NielsKlazenga](https://speciforum.org/u/NielsKlazenga)\ **Post date:** [August 23, 2023, 12:54pm UTC](https://speciforum.org/t/partial-date-options/1278/2 "2023-08-23T12:54:16Z")
Hi Soraya, The ‘Day/Mon’ and ‘Mon’ are not valid date strings. You do not want them in a Date field, as you will get in trouble when you exchange your data. It would also cause a problem in your own database, as you will not be able to sort your dates anymore, or look for records from a certain period. ---
**Author:** ![sorosoro](https://avatars.discourse-cdn.com/v4/letter/s/5f9b8f/32.png) [@sorosoro](https://speciforum.org/u/sorosoro)\ **Post date:** [August 24, 2023, 6:57am UTC](https://speciforum.org/t/partial-date-options/1278/3 "2023-08-24T06:57:17Z")
Hi Niels, Day/Mon alone is still a partial Date, and relevant information, but it’s true that having them in a Date field in the database would create a problem when sharing data. ---
**Author:** ![rdrinkwater](https://avatars.discourse-cdn.com/v4/letter/r/71c47a/32.png) [@rdrinkwater](https://speciforum.org/u/rdrinkwater)\ **Post date:** [August 24, 2023, 12:34pm UTC](https://speciforum.org/t/partial-date-options/1278/4 "2023-08-24T12:34:08Z")
We use startDateVerbatim as ‘Date as Given’ where we can record this kind of partial date. ---
**Author:** ![Grant](https://yyz1.discourse-cdn.com/flex029/user_avatar/speciforum.org/grant/32/4255_2.png) [@Grant](https://speciforum.org/u/Grant)\ **Post date:** [August 24, 2023, 1:48pm UTC](https://speciforum.org/t/partial-date-options/1278/5 "2023-08-24T13:48:13Z")
Hi @sorosoro, Unfortunately, the date fields in the database cannot store day and month information alone. MySQL’s `DATE` fields can store both the day and month along with the year. It does not allow storing only the day and month without the year. This means it is not currently possible to add dates with only ‘Day / Mon’ or ‘Mon’ information only to the same field that we store other dates in. @rdrinkwater’s method is the approach we recommend, where you store this verbatim date information in a text field outside the regular date field for situations like the ones you mentioned in your initial post! ---
**Author:** ![ainsley](https://yyz1.discourse-cdn.com/flex029/user_avatar/speciforum.org/ainsley/32/529_2.png) [@ainsley](https://speciforum.org/u/ainsley)\ **Post date:** [August 25, 2023, 2:59am UTC](https://speciforum.org/t/partial-date-options/1278/6 "2023-08-25T02:59:43Z")
Here when we speak of a _partial_ date we mean a date with _low resolution_ and that is how it is accommodated in MySQL and the meaning in ISO 8601. A known month in an unknown year is not a date so much as a time of year.