Historical Timelines

Historical Timeline (Date Year)

year(prop("Date"))

Historical Timeline (Date Year/Month)

formatDate(prop("Date"), "MMMM")

Simple Historical Timeline (String Century)

if(contains(prop("Year (Range)"), "BC"), unaryMinus(toNumber(replaceAll(prop("Year (Range)"), "-.*", ""))), toNumber(replaceAll(prop("Year (Range)"), "-.*", "")))

Red's Historical Timeline (String Ranges Century)

if(contains(replaceAll(replaceAll(replace(prop("Name"), "[^(]*[(]", ""), "[)][^)]*$", ""), "-.*", ""), "BC"), unaryMinus(toNumber(replaceAll(replaceAll(replace(prop("Name"), "[^(]*[(]", ""), "[)][^)]*$", ""), "-.*", ""))), toNumber(replaceAll(replaceAll(replace(prop("Name"), "[^(]*[(]", ""), "[)][^)]*$", ""), "-.*", "")))