I get this message when I am trying to compare one date with another in generating a view for task lists. The only thing I can think of is there are nulls somewhere but I dont see any dates that are not populated.

I am having a similar problem, but I am trying to create a view that filters the date column to items whose date is within the last year. I have tried [Today] - 365 (with and without =) and it doesn't work. I have also tried the DATE functions:=DATE(YEAR([Today]-1),MONTH([Today]),DAY([Today]))I even tried just =DATE(YEAR([Today]),MONTH([Today]),DAY([Today])) which should be the same as "[Today]" and that still returned the same error. The Sharepoint date calculations are very frustrating.

Hi guys. I have successfully created a view to show recent items in a document library.For the last week I add filter where "Created is greater than [Today]-7"For the last year use [Today]-365.Works for me.Good luckRay Letts

I found that [Today] - 30 does not work, but [Today]-30 does. Apparently, sharepoint does not like spaces! Hope that helps everyone else too...

Removing the spaces does the trick, thanks klb603!

How can I filter by a specific date, rather than relative to the current day? For example, can I say "only show calendar events listed that are between now and February 21"?

I have the same error, has anyone resolved the error msg "filter value is not in a supported date format"?I am trying to create a view that filters items that have a [Start Date] that is in the current month. I have successfully created 2columns that calculate the [FirstDay] and [LastDay] of the current monthFirsttDay=DATE(YEAR([Start Date]),MONTH([Start Date]),1)LastDay=DATE(YEAR([Start Date]),MONTH([Start Date])+1,1)-1I created a filter as follows[Start Date] >= [FirstDay]Iget the error "Filter value is not in supported date format" what am I doing wrong? I am unclear why I am getting this error as I have used SPs built indatesettings to calculate my dates columns.

If I manually type the date displayed in my [FirstDay] column (mm/dd/yyyy) into the same filter equation it works fine.

In case it applies to anyone's situation, you may also got this message when setting up a filter against a hard-coded date, if the date is outside of SharePoint's range for the "Date and Time" data type. Specifically, when attempting to enter a value into a field with the "Date and Time" data type, the following message might appear: "You must specify a valid date within the range of 1/1/1900 and 12/31/8900." I had been testing for conflicts with dates outside of SQL Server's datetime (1/1/1753 - 12/31/9999) and SharePoint would not accept the '1/1/1753' as a filter condition. It is unclear the rationale for that particular date range for the 'date and time' data type in SharePoint. http://stackoverflow.com/questions/1925626/sharepoint-date-and-time-field-limitation