Empty dates returned by remote view as 12/30/1899 Empty dates returned by remote view as 12/30/1899 Wamp1 (Programmer) (OP) 1 Sep 00 21:29 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? RE: Empty dates returned by remote view as 12/30/1899 TomasDill (IS/IT--Management) 2 Sep 00 10:36 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.