Dates: non-CE/BCE

Hello! I am working on a data set with historical events. Some that includes dates that are in BCE. I tried -1600 as a year but was unsuccessful in getting that to come in as BCE. Is there a way to use a dates field with non-Common Era dates?

I see negative dates available in the clicker, but when I select a date of Jan 1 in the year -1600, it saves the field as 1600 AD/CE.


but when I click in after hitting enter on the screen above, the date is in 1600 CE

Hi @Jordan_Stoeger. Unfortunately, we don’t currently support BC dates in date columns. I did share this with the team as a feature request for us to keep in mind.

If you don’t mind answering, does your use case for BC dates include using them in formulas or charts?