Brian,
I updated the image with the highlighted text. As you can tell by the image that I have selected Basic Syntax. It seems that formula can not equal a date range if you substitute the date range with a Date Range function such as MonthToDate the follow error is returned.
I was trying to use your example and save it as a formula to be inserted into the Page Header Section and see the desired date ranges.