# Proposals for change: date formats

**URL:** <https://forum.threesixtygiving.org/t/proposals-for-change-date-formats/46>\
**Category:** Standard\
**Created:** [18 October 2017 19:31 UTC](https://forum.threesixtygiving.org/t/proposals-for-change-date-formats/46 "2017-10-18T19:31:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![BobHarper](https://yyz2.discourse-cdn.com/flex032/user_avatar/forum.threesixtygiving.org/bobharper/32/36_2.png) [@BobHarper](https://forum.threesixtygiving.org/u/BobHarper)\
**Post date:** [18 October 2017 19:31 UTC](https://forum.threesixtygiving.org/t/proposals-for-change-date-formats/46/1 "2017-10-18T19:31:27Z")

</div>

Hi all

We have three proposals for changes to the Standard and the schema relating to the three different kinds of dates that the 360 Giving Data Standard supports:

1. [An explicit date-time format for ‘Last Modified’](https://github.com/ThreeSixtyGiving/standard/issues/218)
2. [Explicit date or date-time formats for known date fields](https://github.com/ThreeSixtyGiving/standard/issues/219)
3. [Explicite date or date-time formats for uncertain dates](https://github.com/ThreeSixtyGiving/standard/issues/220)

You can also see these issues here [https://github.com/ThreeSixtyGiving/standard/projects/5](https://github.com/ThreeSixtyGiving/standard/projects/5)

Each of these have specific proposals, but they each relate to how dates are to be formatted in published data, impacting on the schema and documentation. It will also require some changes to the data validation tool to warn users of incorrectly-formatted dates.

For the most part, they provide clarity for publishers about acceptable formats, and assurances for users that dates/date-times will be consistent across published datasets.

They also provide consistency between the guidance in the documentation, and what the schema allows. We think that impacts on publishers should be limited, as most are already publishing to the proposed formats. It also provides some reassurance that for uncertain dates, it is fine to use a year or a year-month, rather than having a specific date.

---

<div class="post-metadata">

**Author:** ![BobHarper](https://yyz2.discourse-cdn.com/flex032/user_avatar/forum.threesixtygiving.org/bobharper/32/36_2.png) [@BobHarper](https://forum.threesixtygiving.org/u/BobHarper)\
**Post date:** [7 November 2017 11:33 UTC](https://forum.threesixtygiving.org/t/proposals-for-change-date-formats/46/2 "2017-11-07T11:33:06Z")

</div>

There’s a version for Standard documentation which covers all of these changes here: [http://standard.threesixtygiving.org/en/date-validation](http://standard.threesixtygiving.org/en/date-validation)

Note in particular the new section which gives guidance on using dates and how to apply in the various cases [http://standard.threesixtygiving.org/en/date-validation/reference/#field-guidance](http://standard.threesixtygiving.org/en/date-validation/reference/#field-guidance)

---

<div class="post-metadata">

**Author:** ![davidkane](https://yyz2.discourse-cdn.com/flex032/user_avatar/forum.threesixtygiving.org/davidkane/32/80_2.png) [@davidkane](https://forum.threesixtygiving.org/u/davidkane)\
**Post date:** [15 November 2017 10:38 UTC](https://forum.threesixtygiving.org/t/proposals-for-change-date-formats/46/3 "2017-11-15T10:38:12Z")

</div>

Really like the tips for using excel included in the field guidance.