Reference - Year and Date Compatibility

GGP ensures compatibility with modern and legacy date standards, including support for four-digit year formats and the Gregorian calendar system.

---

📅 Year 2000 (Y2K) Compatibility

• All Date fields in GGP store the year as a 4-digit value.

• When entering a 2-digit year:

  • If the value is 50–99, GGP assumes 19xx (e.g. 51 becomes 1951).

  • If the value is 00–49, GGP assumes 20xx (e.g. 23 becomes 2023).

• To record dates before 1950, users must enter the full 4-digit year.

• GGP fully supports leap year validation, including the date 29 February 2000, in accordance with BSI Year 2000 compliance standards.

✅ Example:
01/01/50 is interpreted as 01/01/1950
01/01/49 is interpreted as 01/01/2049

---

📜 Gregorian Calendar Considerations

• Microsoft SQL Server does not support dates earlier than 1 January 1753.

• When working with historic records or events, store years only instead of full dates if they precede 1753.

• Attempting to migrate or store dates earlier than this in SQL-based overlays will result in data errors or import failures.