![]() ![]() When any argument exceeds the accepted range for that argument, it increments to the next larger unit as appropriate. ![]() To be sure the function returns the proper value, use a four-digit year. For all other year arguments, use a four-digit year (for example, 1800).Įarlier versions of Windows interpret two-digit years based on the defaults described earlier. The default values between 30 and 99 are interpreted as the years 1930–1999. The default settings are that values between 0 and 29, inclusive, are interpreted as the years 2000–2029. Under Windows 98 or Windows 2000, two digit years for the year argument are interpreted based on user-defined machine settings. Here the DateSerial function returns a date that is the day before the first day ( 1 - 1), two months before August ( 8 - 2), 10 years before 1990 ( 1990 - 10) in other words, May 31, 1980. ![]() The following example uses numeric expressions instead of absolute date numbers. However, you can also specify relative dates for each argument by using any numeric expression that represents some number of days, months, or years before or after a certain date. To specify a date, such as December 31, 1991, the range of numbers for each DateSerial argument should be in the accepted range for the unit that is, 1–31 for days and 1–12 for months. Number between 1, inclusive, or a numeric expression. The DateSerial function syntax has these named arguments: Part Returns a Variant ( Date) for a specified year, month, and day. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |