[GH-ISSUE #7291] [Bug] Dates before 1979-01-01 not possible #3232

New issue

Open

opened 2026-03-23 21:28:35 +00:00 by mirror · 2 comments

mirror commented

2026-03-23 21:28:35 +00:00

Owner

Originally created by @beo3000 on GitHub (Jan 26, 2025).
Original GitHub issue: https://github.com/AppFlowy-IO/AppFlowy/issues/7291

Bug Description

It seems to be impossible, to use date values in da grid column of type date, before 1979-01-01. So it is not possible to store data with historical dates in grids.

How to Reproduce

Create a grid, add a column of type date. Tyr to set its value to 1949-01-01

Expected Behavior

It should be possible to use each date, starting at 0001-01-01 (yyyy-MM-dd)

Operating System

Win 100

AppFlowy Version(s)

0.8.2

Screenshots

Additional Context

No response

Originally created by @beo3000 on GitHub (Jan 26, 2025). Original GitHub issue: https://github.com/AppFlowy-IO/AppFlowy/issues/7291 ### Bug Description It seems to be impossible, to use date values in da grid column of type date, before 1979-01-01. So it is not possible to store data with historical dates in grids. ### How to Reproduce Create a grid, add a column of type date. Tyr to set its value to 1949-01-01 ### Expected Behavior It should be possible to use each date, starting at 0001-01-01 (yyyy-MM-dd) ### Operating System Win 100 ### AppFlowy Version(s) 0.8.2 ### Screenshots ![Image](https://github.com/user-attachments/assets/872785d1-06a2-4bf9-83bf-fdf247c776b2) ### Additional Context _No response_

mirror added the

improvements

database

labels

2026-03-23 21:28:35 +00:00

mirror commented

2026-03-23 21:28:36 +00:00

Author

Owner

@91FAhmed commented on GitHub (Feb 5, 2025):

i will look into it maybe because the date string (yyyy-mm-dd) kept constant at a range but no guarantee

@91FAhmed commented on GitHub (Feb 5, 2025): i will look into it maybe because the date string (yyyy-mm-dd) kept constant at a range but no guarantee

mirror commented

2026-03-23 21:28:36 +00:00

Author

Owner

@Skelbti commented on GitHub (Jan 24, 2026):

I am switching from Notion to AppFlowy and need to create historical databases with many dates after 1970. Is it possible to fix the date issue?

@Skelbti commented on GitHub (Jan 24, 2026): I am switching from Notion to AppFlowy and need to create historical databases with many dates after 1970. Is it possible to fix the date issue?

mirror referenced this issue

2026-03-23 23:15:27 +00:00

[PR #5011] [MERGED] feat: select option cell editor revamp #6579