Author: K Z

The MonthName function returns the name of the month for the specified date. Syntax MonthName(month[,toabbreviate]) Parameter Description Month − A required parameter. It specifies the number of the month.Toabbreviate − An optional…

The Year function returns an integer that represents a year of the specified date. Syntax Year(date) Example Add a button and add the following function. Private Sub Constant_demo_Click() msgbox(Year("2013-06-30")) End…

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…

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…

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…

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…

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 -…

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 -…

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…

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…