Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Support for BC in addition to AD Dates

cancel
Showing results for 
Search instead for 
Did you mean: 
Jeremy_Oglesby
14 - Jupiter
14 - Jupiter

I’d like to request support for BC dates, or “negative” years. The Timeline Block is willing to display “negative” years, and I think it would be neat to be able to build a History Timeline in Airtable that could span back into Ancient, BC history. Sadly, the furthest back I can get is a “year 0”.

CleanShot 2020-07-10 at 22.02.55@2x

And even the Date Picker on the Date field is willing to scroll backwards into negative years, but then when a date is selected, it inputs it as the positive inverse year:

CleanShot 2020-07-10 at 22.19.01@2x

CleanShot 2020-07-10 at 22.19.15@2x

I’ve been fiddling with DATETIME_PARSE() formulas and can’t seem to get anything to produce a “negative” year output.

Would love to see support for this, even if the use-cases are rather narrow :slightly_smiling_face:

7 Comments
kuovonne
18 - Pluto
18 - Pluto

Great product suggestion.

You wouldn’t happen to be homeschooling ancient history, would you?

Jeremy_Oglesby
14 - Jupiter
14 - Jupiter

:slightly_smiling_face: ⠀⠀⠀⠀⠀⠀⠀⠀

mitt_coats
4 - Data Explorer
4 - Data Explorer

Did you ever find a solution? I’m looking for same thing

Maia_Nebula
4 - Data Explorer
4 - Data Explorer

Can’t agree more!! I really need this function, too. Hope Airtable Team supports your request.

Jeremy_Oglesby
14 - Jupiter
14 - Jupiter

BUMP

I would still like this, @Airtable

ecl
4 - Data Explorer
4 - Data Explorer

I am also looking for this funktion, I hope the airtable team finds an ear for this.

jamesDC
4 - Data Explorer
4 - Data Explorer

Would also love to see this functionality added.