Most of the users face some problems with not having the right operators in the Filter Criteria dialog of a DataForm Web Part speciall when they are trying to filter by was a date.
After doing lots of R & D I found out two reasons for not able to see this option. Here is the resolution
Resolution 1
One of my sharepoint there was a Lookup column which referred to a list that no longer existed. Note the lack of List name for where it’s getting information:
After deleting this column, I am able to see my all the missing options
After deleting this column, I am able to see my all the missing options
Resolution 2
I also got another solution from
http://geekswithblogs.net/naijacoder/archive/2007/10/15/116060.aspx
Once of my end user have same problem and using option 2, his problem was resolved.
