| Reference > TDBDateX Object > TDBDateX Object Properties > Value Property (TDBDateX) |
Value Property (TDBDateX)
This property returns or sets the underlying date time serial value.
object.Value= variant
Read/Write at run time. Not available at design time.
100/01/0 00:00:00 - 9999/12/31 23:59:59 (current system date is the default)
The default value will be the current system date.
The required date is normally a string expression representing a date from January 1, 100 through December 31, 9999. The date value can also be any expression that can represent a date, a time, or both a date and time, in that range.
If date is a string that includes only numbers separated by valid date separators, Value recognizes the order for month, day, and year according to the Short Date format you specified for your system. Value also recognizes unambiguous dates that contain month names, either in long or abbreviated form. For example, in addition to recognizing 12/30/1991 and 12/30/91, Value also recognizes December 30, 1991 and Dec. 30, 1991.
The date value in the Value property will be synchronized with the DateSerial and the TimeSerial properties. Whenever the Value is changed, the changes will be reflected in the DateSerial and the TimeSerial. If either the DateSerial or the TimeSerial set to Null, the Value will be also set to Null.
This is the default property of the TDBDateX object.
If a year part of the given date is omitted, Value uses the current year from your system date.
If the date part is omitted, the date serial will be set to 0, which equals to Dec. 30, 1899. If the time part is omitted, the time serial will be also set to 0, which equals to 00:00:00.
If the date value includes invalid date time information (such as "89:98"), an error occurs.
Null value is not a valid date that can be converted to a date, but can be used as a Variant subtype, indicating that a variable or a property contains no valid data.
See Also
DateSerial Property (TDBDateX)