>Actually, I mean the SQL DATE() command as in:
>
>SELECT Field1, Field2, DATE() As CurrentSystemDate FROM SomeTable
>
>This is not VFP, but a Visual Basic front end and a SQL Server back end.
I don't have DATE() as an available function in SQL Server. Are you sure about that? I use GetDate() when I need the date.