>>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
>
>You don't need in filter. The only thing you should do is
>IF table1.datefield<>date() and table1.datefield<>date()+2
> Replace table1.datefield with date()+2
>Endif
Thanks Ed, I put that in the valid event on the form for that entry and it works well!
Thanks, Brad.
He is there and He is not Silent.