DOCERR: How to Create a Blank DateTime Documented Incorrectly (141084)



The information in this article applies to:

  • Microsoft Visual FoxPro for Windows 3.0

This article was previously published under Q141084

SUMMARY

Page 32 of the "Developers Guide" states "To assign blank DateTime values, use braces with a colon." Based on the documentation, the following uses should generate blank datetime values, but they do not.

Method One

tBlankDate1 = {:}
tBlankDate1 = { }  &&blank space between brackets
				
-or-
STORE {:} TO tBlankDate1
STORE { } TO tBlankDate1
				
The result is "12/30/1899 12:00:00 AM" -- Not a blank DateTime.

Method Two

tBlankDate1 = {}   && no blank spaces between brackets
tBlankDate1 = {/}
				
-or-
STORE {} TO tBlankDate1
STORE {/} TO tBlankDate1
				
The result is " / / " -- A blank date, but time is not showing.

MORE INFORMATION

To get a blank DateTime value use either of the following:
tBlankDate1 = {/:}
tBlankDate1 = {//:}
				
-or-
STORE {/:} TO tBlankDate1
STORE {//:} TO tBlankDate1
				
The result is " / / : : AM"

The incorrect references to assign a blank DateTime value are:

  • The Developers Guide refers to using {:} for assigning a blank DateTime.
  • The Help file refers to using {},{/},{ } for assigning a blank DateTime.
These references have been corrected in the Visual FoxPro 3.0b Help.

Modification Type:MajorLast Reviewed:12/11/1999
Keywords:KB141084