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 suits a specific condition.

Date Functions

S.No. Function & Description
1 DateA Function, which returns the current system date.
2 CDateA Function, which converts a given input to date.
3 DateAddA Function, which returns a date to which a specified time interval has been added.
4 DateDiffA Function, which returns the difference between two time period.
5 DatePartA Function, which returns a specified part of the given input date value.
6 DateSerialA Function, which returns a valid date for the given year, month, and date.
7 FormatDateTimeA Function, which formats the date based on the supplied parameters.
8 IsDateA Function, which returns a Boolean Value whether or not the supplied parameter is a date.
9 DayA Function, which returns an integer between 1 and 31 that represents the day of the specified date.
10 MonthA Function, which returns an integer between 1 and 12 that represents the month of the specified date.
11 YearA Function, which returns an integer that represents the year of the specified date.
12 MonthNameA Function, which returns the name of the particular month for the specified date.
13 WeekDayA Function, which returns an integer(1 to 7) that represents the day of the week for the specified day.
14 WeekDayNameA Function, which returns the weekday name for the specified day.

Time Functions

S.No. Function & Description
1 NowA Function, which returns the current system date and time.
2 HourA Function, which returns an integer between 0 and 23 that represents the hour part of the given time.
3 MinuteA Function, which returns an integer between 0 and 59 that represents the minutes part of the given time.
4 SecondA Function, which returns an integer between 0 and 59 that represents the seconds part of the given time.
5 TimeA Function, which returns the current system time.
6 TimerA Function, which returns the number of seconds and milliseconds since 12:00 AM.
7 TimeSerialA Function, which returns the time for the specific input of hour, minute and second.
8 TimeValueA Function, which converts the input string to a time format.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s