DateValue: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 12: | Line 12: | ||
<pre> | <pre> | ||
Rem DateValue Example | |||
'DateValue returns a date | 'DateValue returns a date | ||
Dim IndepDay, Birthday | |||
IndepDay = DateValue("July 4, 1776") | IndepDay = DateValue("July 4, 1776") | ||
Birthday = DateValue("Dec 27 1970") | Birthday = DateValue("Dec 27 1970") | ||
Print "Independence Day:", IndepDay | |||
Print "My birthday:", Birthday | |||
</pre> | </pre> | ||
| Line 31: | Line 31: | ||
== Related Items == | == Related Items == | ||
[[format| | [[format|Format]], [[timevalue|TimeValue]] | ||
[[Category:Language Reference]] | [[Category:Language Reference]] | ||
Revision as of 00:32, 24 August 2012
DateValue(date)
Description
DateValue returns a date. The required parameter, date, is usually a string, but any expression that can represent a date, a time, or a date and time ranging from January 1, 100 to December 31, 9999, can be used.
If date is a string that consists of numbers separated by date separators, it recognizes the order for month, day, and year according to the Short Date format specified for your system. If the year is left out of date, the current year is used. Unambiguous month names as strings will be recognized in either long or abbreviated form.
Date separators are characters that separate day, month, and year when a date is formatted as a string, they are determined by your system settings.
Example
Rem DateValue Example
'DateValue returns a date
Dim IndepDay, Birthday
IndepDay = DateValue("July 4, 1776")
Birthday = DateValue("Dec 27 1970")
Print "Independence Day:", IndepDay
Print "My birthday:", Birthday
Output
Independence Day: 7/4/1776
My birthday: 12/27/1970
(''sample date output is machine dependant'')