Hi Jason,

> The problem is if I need to go back and modify the view. If I attempt to modify, I get the following message "SQL: Column 'SYSDATE' is not found.".

Can't you upgrade to at least VFP 8? A modified view designer that deals much better with more complex views (complex means calling a function without parenthesis <g>) than then one in VFP 7.