VisualBasic Script Date Functions 142 codes

1 A destroying the old values by using the Preserve keyword

2 Aaaa - Displays the full, localized name of the day

3 Add value to Date

4 AMPM - Uses the 12-hour clock and displays AM or PM as appropriate

5 AMPM - Uses the 12-hour clock and displays the AM or PM string literal defined for the system

6 AP - Uses the 12-hour clock and displays A or P as appropriate

7 Break a single date down to its individual components using the DatePart function

8 C - Displays the date

9 Characters for Creating Your Own Number Formats

10 Currency

11 Currency - The number is displayed with two decimal places, a thousand separator, and the currency symbol appropriate to th

12 D - Displays the date (1 to 31) without a leading zero for single-digit numbers

13 Date and Now

14 Date returns a VariantDate containing the current date according to your computer

15 Date separator (also locale-dependent)

16 DateAdd returns the result of adding or subtracting a specified period of time to a date

17 DateAdd(interval, number, date) returns a VariantDate containing the date of the specified interval after the specified dat

18 DateDiff returns the interval of time between two dates

19 DateDiff() function returns the difference between two dates The unit for the difference is specified as a string ( s for s

20 DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]]) returns the interval between two specified dates

21 DateDiff(m, 3152000, Now)

22 DateDiff(m, Now, 101003)

23 DateDiff(yyyy, Now, 101003)

24 DatePart returns Prints the Year

25 DatePart(d, Now)

26 DatePart(h, Now)

27 DatePart(m, Now)

28 DatePart(n, Now)

29 DatePart(q, Now)

30 DatePart(s, Now)

31 DatePart(w, Now)

32 DatePart(ww, Now)

33 DateSerial(4, 11, 23) returns 11232004

34 DateSerial(year, month, day) returns a VariantDate containing the date for the specified year, month, and day

35 DateValue(date) returns a VariantDate containing the specified date

36 DateValue(Nov, 23 04) returns 11232004

37 Day(Date)

38 Day(date) returns a VariantInteger between 1 and 31, inclusive, representing the day of the month for date

39 Dd - Displays the date with a leading zero for single-digit numbers (01 to 31)

40 Ddd - Displays the day as a three-letter abbreviation (Sun, Mon, Tue, Wed, Thu, Fri, Sat) with no period

41 Dddd - Displays the full name of the day

42 Ddddd - Displays the complete date (day, month, and year) in the systems short date format

43 Dddddd - Displays the complete date (day, month, and year) in the systems long date format

44 Declaring and Working with Dynamic Arrays

45 Delivery Date Maint

46 Difference between two dates in days and months

47 Dynamic Arrays

48 Fixed - The number is displayed with two decimal places and at least one integer place

49 For example, the following statement returns Saturday, April 01, 2006

50 Format Demo

51 Format the date type value

52 Format time as mmmm_yyyy

53 Format(datDateTime, dd mmm yy)

54 Format(datDateTime, Long Date)

55 Format(datDateTime, mm dddd hh

56 Format(datDateTime, yyyy-mm-dd)

57 Format(dblNumber #####0)

58 Format(dblNumber ###,##0 00)

59 Format(dblNumber 0 00)

60 Format(dblNumber 000000 00)

61 Format(Now, ddd)

62 Format(Now, dddd)

63 Format(Now, ddddd)

64 Format(Now, dddddd)

65 Format(Now, d-mmmm-yy)

66 Format(Now, d-mmm-yy)

67 Format(Now, Hh

68 Format(Now, mmmm d, yyyy)

69 Format(Now, ttttt)

70 Formatting the date and time with format function

71 General Number - The number is displayed with no thousand separator

72 Get the weekend between startDate and endDate

73 H - Displays a number from 0 to 23 giving the hour

74 Hh - Displays a number from 00 to 23 giving the two-digit hour

75 Hour(time) returns VariantInteger between 0 and 23, inclusive, representing the hour for time

76 M - Displays an integer from 1 to 12 giving the number of the month without a leading zero on single-digit months

77 Mm - Displays a number from 01 to 12 giving the two-digit number of the month When used after h returns minutes instead of

78 Mmm - Displays the month as a three-letter abbreviation (except for May) without a period

79 Mmmm - Displays the full name of the month

80 MonthName returns the text string associated with a month number

81 MonthName(Month(Date))

82 MonthName(Month(Date), True)

83 MonthName(month) returns A String containing the name of the month represented by month

84 N - Displays a number from 0 to 60 giving the minute

85 Nn - Displays a number from 00 to 60 giving the two-digit minute

86 Now returns a VariantDate containing the current date and time according to your computer

87 OnOff - A non-zero number is displayed as On; a zero number is displayed as Off

88 Oooo - Displays the full localized name of the month

89 Percent - The number is displayed multiplied by 100, with two decimal places, and with a percent sign

90 Prints the Day of the Year

91 Prints the Month Number

92 Prints the Quarter Number

93 Prints the Week of the Year

94 Program an event for 3

95 Q - Displays a number from 1 to 4 giving the quarter of the year

96 Returns a currency formatted with four decimal places

97 Returns the number of weeks between June 3, 2006 and September 30, 2006

98 S - Displays a number from 0 to 60 giving the second

99 Scheduling a Macro to Run x Minutes in the Future

100 Scheduling a Verbal Reminder

101 Scientific - The number is displayed in scientific notation

102 Second(time) returns A VariantInteger between 0 and 59, inclusive, representing the second for time

103 Ss - Displays a number from 00 to 60 giving the two-digit second

104 Standard - The number is displayed with two decimal places, at least one integer place, and a thousand separator (when need

105 The Currency data type allows for positive and negative numbers with up to 15 digits to the left of the decimal point and 4

106 The Weekday function values

107 Theres a potential problem when you try to resize the array

108 Timer returns a Single giving the number of seconds that have elapsed since midnight

109 TimerValue function returns time value

110 TimeSerial(9, 0, 0) returns 9

111 TimeSerial(hour, minute, second) returns a VariantDate containing the time for the specified hour, minute, and second

112 TimeValue(9

113 TimeValue(time) returns A VariantDate containing the time for time

114 To schedule an event relative to the current time - for example, 20 minutes from now

115 Transpose() sub procedure is using a dynamic array that is re-dimensioned with two dimensions

116 TrueFalse - A non-zero number is displayed as True; a zero number is displayed as False

117 Ttttt - Displays the full time (hour, minute, and second) in the systems default time format

118 Use DateDiff function

119 Use DateSerial and Weekday

120 Use Hour to get the hour value from a date

121 Use Now to retrieve current Date and Time

122 Use ReDim to create dynamic array

123 Use the OnTime method to run a VBA procedure on a particular day

124 Use the Preserve keyword to keep the values

125 Use Weekday to get the weekday value from a date

126 Use year function to get the year

127 Using a Dynamic Array

128 Using DatePart(interval, date[,firstdayofweek[, firstweekofyear]]) to Parse Dates

129 Using the Format Function to Format an Expression

130 VBA Date function and the Mod operator

131 W - Displays an integer from 1 (Sunday) to 7 (Monday) containing the day of the week

132 Weekday(Date)

133 Weekday(date) returns A VariantInteger containing the day of the week represented by date

134 WeekdayName (weekday) returns A String containing the weekday denoted by weekday

135 WeekdayName(Weekday(Date))

136 WeekdayName(Weekday(Date), True)

137 Ww - Displays an integer from 1 to 54 giving the number of the week in the year

138 Y - Displays an integer from 1 to 366 giving the day of the year

139 Year(Date)

140 YesNo - A non-zero number is displayed as Yes; a zero number is displayed as No

141 Yy - Displays a number from 00 to 99 giving the two-digit year

142 Yyyy - Displays a number from 0100 to 9999 giving the four-digit year