>>I have an application that requires the date entered in the database to be equal to or 2 days ahead of the current date. For the life of me I can't seem to get the filter on the database to be configured for the right syntax.
>>
>>Anyone have a suggested code for the filter on the field validation rule?
>>
>>Thanks, Brad
>
>What do you mean by filter? To have a date field in the database default to 2 days from today, put date() + 2 in the default value.
I Just read the question more carefully and I think I understand. In the field validation rule, put:
table.date<=(DATE()+2).AND.table.date=>DATE()

This will play funny tricks on you though, unless no records stay in the table for more than 2 days. Are you sure that that is what you want?