Date Data Type

See Also

Choose the Date data type to store dates without time values.

Visual FoxPro 6.0 (and Visual FoxPro 5.0) support a strict Date and DateTime format that provides year 2000 compliance. It’s recommended that you use strict date formats for all Date and DateTime constants and expressions. For more information about strict date formats, see Year 2000 Date Support in Chapter 33, “Programming Improvements” in the Programmer’s Guide.

In both Date and DateTime data types, the following rules apply:

• {00:00:00AM} is equivalent to {12:00:00AM}, Midnight.
  
  
• {00:00:00PM} is equivalent to {12:00:00PM}, Noon.
  
  
• {00:00:00} to {11:59:59} is equivalent to {12:00:00AM} to {11:59:59AM}.
  
  
• {12:00:00} to {23:59:59} is equivalent to {12:00:00PM} to {11:59:59PM}.