When you call the DateValue function, you can use the following enumeration members in your code in place of the actual values.
| Member | Constant | Description |
|---|---|---|
| GeneralDate | vbGeneralDate | For real numbers, displays a date and time. If the number has no fractional part, displays only a date. If the number has no integer part, displays time only. Date and time display is determined by your computer's regional settings. |
| LongDate | vbLongDate | Displays a date using the long-date format specified in your computer's regional settings. |
| ShortDate | vbShortDate | Displays a date using the short-date format specified in your computer's regional settings. |
| LongTime | vbLongTime | Displays a time using the long-time format specified in your computer's regional settings. |
| ShortTime | vbShortTime | Displays a time using the short-time format specified in your computer's regional settings. |
Note You can access your computer's regional settings by double-clicking the Regional Options icon, found in the Control Panel.