In SP2013 view filters, if I want to subtract say a week from today I can do
[Today]-7 which works. But I want to remove 30 years, which is
[Today]-10950 however it complains that the date is not in a supported format. It seems to support until 9999.
=DATE(YEAR([Today])-30,MONTH([Today]),DAY([Today])) but same thing.
Does anyone know?