How do you store a date when you don't actually know the date?
"Born around 1926" or "died sometime in 1937" doesn't fit neatly into a database
date column.
I built laravel-edtf to handle fuzzy, approximate, and uncertain dates in Laravel, with Eloquent casts, queryable date ranges, and a Filament date picker.
Preserve the uncertainty without breaking your existing date queries.
https://github.com/smwks/laravel-edtfGitHubGitHub - smwks/laravel-edtfContribute to smwks/laravel-edtf development by creating an account on GitHub.
commit 3d9ae0e
Maybe separate billable month/day/year columns, where null represents “unknown”? You could even expand that to add a -variance column to each so you know writhing that column’s number of years/months/days, or a Boolean “approximate” flag for each column.
Will have to keep an eye on this - I am about to deal with this issue on ZooChat. We have a gallery of over 830,000 images from zoos around the world (growing rapidly!) and one of my next projects is to clean those photos up and make navigation easier. I want to group the photos…