I have been trying to create an Issues Web Database on one of our MOSS 2010 servers, but I keep getting the error "The formula contains a syntax error or is not supported" when I try to. I have tried this on one of our other 2010 environments and it works
fine but for some reason it happens just one this one.
In the error logs I found this:
Error updating field: List: Issues, SchemaXml: <Field DisplayName="OpenedDate" Type="DateTime" Required="TRUE" Format="DateOnly" xmlns="http://schemas.microsoft.com/sharepoint/soap/" Name="OpenedDate"><DefaultFormula>=TODAY()</DefaultFormula><DefaultFormulaValue></DefaultFormulaValue><Validation
Message="Value must be greater than 1/1/1900.">=OpenedDate>=DATETIME(1900,1,1,0,0,0)</Validation></Field>. Exception: Microsoft.SharePoint.SPException: The formula contains a syntax error or is not supported.
Does anyone have an idea as to what the cause might be?
View Complete Post