Empty dates returned by remote view as 12/30/1899

[Wamp1]

When I use a remote view to access a VFP6 table the sql returns an empty date field with the date 12/30/1899 rather than empty. Can anyone tell me how I resolve this problem?

 

[TomasDill]

Use .NULL. values for empty date rather than SQL empty date. This also require some effort in VFP to check for .NULL. values, as well as set appropriate properties of controls to do not display 'NULL' when date is empty.
If that date field is read-only, use expression in query and return character string instead of date data type, which will convert date to its string representation, or return empty string when date is empty on SQL serevr.