VBA – Month Function
The Month function returns a number between 1 and 12 that represents the month of the specified date. Syntax Month(date) Example Add a button and add the following function. Private…
VBA
VBA – Day Function
The Day function returns a number between 1 and 31 that represents the day of the specified date. Syntax Day(date) Example Add a button and add the following function. Private…
VBA – IsDate Function
A Function, which returns a Boolean value whether or not the given input isdate. Syntax IsDate(expression) Example Add a button and add the following function. Private Sub Constant_demo_Click() msgbox("Line 1…
VBA – DatePart Function
A Function, which returns the specific part of the given date. Syntax DatePart(interval,date[,firstdayofweek[,firstweekofyear]]) Parameter Description Interval − A required parameter. It can take the following values.d - day of the year.m…
VBA – DateDiff Function
A Function, which returns the difference between two specified time intervals. Syntax DateDiff(interval, date1, date2 [,firstdayofweek[, firstweekofyear]]) Parameter Description Interval − A required parameter. It can take the following values.d -…
VBA – DateAdd Function
A Function, which returns a date to which a specified time interval has been added. Syntax DateAdd(interval,number,date) Parameter Description Interval − A required parameter. It can take the following values.d -…
VBA – CDate Function
The Function converts a valid date and time expression to type date. Syntax cdate(date) Example Add a button and add the following function. Private Sub Constant_demo_Click() Dim a as Variant…
VBA – Date Function
The Function returns the current system date. Syntax date() Example Add a button and add the following function. Private Sub Constant_demo_Click() Dim a as Variant a = date() msgbox "The…
VBA – Date-Time Function
VBScript Date and Time Functions help the developers to convert date and time from one format to another or to express the date or time value in the format that…
VBA – String Reverse Function
The StrReverse function reverses the specified string. Syntax StrReverse(string) Example Add a button and add the following function. Private Sub Constant_demo_Click() msgbox("Line 1 : " & StrReverse("VBSCRIPT")) msgbox("Line 2 :…