>Bob, that's a cool solution but now I have a twist to all this. During prototyping I'm using VFP as the backend. So I cannot use the CONVERT() function but use the DTOS() function on the date field. Will the upsizing convert this to the CONVERT() SQL function?

I don't think it is that smart. But since the code would be in a remote view, it won't take much to modify. Your source code (programs etc) won't have to be modified.