DOCERR: How to Create a Blank DateTime Documented Incorrectly

ID: Q141084

The information in this article applies to:

Microsoft Visual FoxPro for Windows, version 3.0

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.

Additional query words: VFoxWin blank date time datetime

Keywords : FxprgGeneral
Version : WINDOWS:3.0
Platform : WINDOWS
Issue type :