Sort For BC and AD (BCE/CE)

Sort For BC and AD (BCE/CE)

Master Tag

Tips & Tricks

Created

Feb 2, 2021 10:42 PM

How It Works

https://www.redgregory.com/notion/2021/2/2/notion-trick-sorting-years-for-bc-and-ad-or-bce-and-ce

Usage

unaryMinus

Contains

toNumber

Web Tags

Database

Formula

Alternatives

Cover

Week Of Month (10).png

🎑

Special Sorting For BC And AD

Year

Event

279 BCE

Battle of Asculum: A Greek force led by the Epirote king Pyrrhus defeated a Roman army at modern Ascoli Satriano, despite suffering heavy losses.

180 BCE

The Lex Villia annalis, which established minimum ages for high office and required a minimum of two years in private life between offices, was passed.

167 BCE

Third Macedonian War: The Macedonian king Perseus of Macedon was captured. Macedonia was divided into four districts subject to Rome.

133 BCE

The Tribune of the Plebs Tiberius Gracchus was beaten to death by a mob of senators led by the Pontifex Maximus Publius Cornelius Scipio Nasica Serapio (consul 138 BC).

73 CE

Siege of Masada: Roman forces breached the walls of Masada, a mountain fortress held by the Jewish extremist sect the Sicarii.

271 CE

Tetricus I, praeses of Gallia Aquitania was acclaimed emperor of the Gallic Empire. He appointed his natural son Tetricus II to rule jointly with him.

Formula


if(contains(prop("Year"), "BCE"), unaryMinus(toNumber(prop("Year"))), toNumber(prop("Year")))