Declarations Section, AddBusinessDays Function, AddMonths Function, AddMonthsTest Sub, AgeDifference Function, Calendar Function, DateTimeSortedString Function, DateTimeTo8CharString Function, DateTimeToDouble Function, DateTo3CharString Function, DateTo4CharString Function, DayNumber Function, DayOfYear Function, DaysInMonth Function, DaysInYear Function, DaysSinceZero Function, DecimalToHMS Function, DoubleToDateTime Function, Easter Function, EndOfAddMonths Function, EndOfAddMonthsTest Sub, FirstBusinessDayOfMonth Function, FirstDayOfMonth Function, FirstDayOfPeriod Function, FirstDayOfWeek Function, FirstDayOfWeekInMonth Function, FirstWeekdayOfMonth Function, HMSToDecimal Function, IsLeapYear Function, IsLeapYearTest Sub, LeapYearsVerify Sub, IsWeekday Function, IsWeekendDay Function, JulianDate Function, JulianDay Function, LastBusinessDayOfMonth Function, LastDayOfMonth Function, LastDayOfPeriod Function, LastDayOfWeek Function, LastDayOfWeekInMonth Function, LastWeekdayOfMonth Function, MoonPhase Function, MoonPhaseName Function, NextDayOfWeek Function, NextDayOfWeekOnOrAfter Function, NextWeekday Function, NowTimer Function, NowUnique Function, NowUniqueWithSleep Function, NthDayOfWeekInMonth Function, NumberWorkDays Function, NumberWorkDaysTest Sub, ParseDateTime Function, PreviousDayOfWeek Function, PreviousDayOfWeekOnOrBefore Function, PreviousWeekday Function, SeasonName Function, ShipBells Function, WeekdayFmString Function, WeekdayMonthAndDayToMatchingYears Function, WeekdayToString Function, UniqueYearsVerify Sub, WorkDays Function, WorkDaysTest Sub, YearFraction Function, YearFractionTest Sub, Zodiac Function, ZodiacSample Sub

Declarations Section

Add Business Days Function

Add a number of business days to a date or subtract a number of business days from a date.

Add Months Function

Add a number of months to the given date.

Add Months Test Sub

Compare the AddMonths function to Excel's EDATE function.

Age Difference Function

Return the difference in years between the two dates. vCountTime determines whether Time is considered within the calculation.

Calendar Function

Produce a calendar for a month that resembles the output of the UNIX cal command.

Date Time Sorted String Function

"Date And Time To Sorted String" Convert a date/time value into a numeric string which can be used to sort the date into chronological order. Components of the date and time are ordered from the most significant (the year) to the least significant (the second).

Date Time To 8 Char String Function

"Date And Time To Eight Character String" Converts date/time value into an eight-character string that can be used as a (DOS short) file name. The range is one decade. The resolution is one minute.

Date Time To Double Function

Takes a Date/time value an converts it into the floating-point number of days since 12/30/1899 00:00. This is different that using the CDbl function to convert a Date to a Double because of the way that Microsoft represents pre-1900 dates. Inverse of the DoubleToDateTime function.

Date To 3 Char String Function

"Date To Three Character String" Converts the date portion of a date/time value into a three-character string. The resolution is one day. The range is one decade. This string is suitable for use as the prefix or extension for a file name.

Date To 4 Char String Function

"Date To Four Character String" Converts the date portion of a date/time value into a four-character string. The resolution is one day. The range is one decade. This string is suitable for use as the prefix for a file name.

Day Number Function

Return the number of days since 1/1/1 plus one.

Day Of Year Function

Return the day of the year for a given date. The days are numbered consecutively starting with the first day of the year.

Days In Month Function

Return the number of the last day of the month for a given date. Same as returning the last day of the month.

Days In Year Function

Return the number of days in the year.

Days Since Zero Function

Return the number of days since 00/00/0000.

Decimal To HMS Function

"Decimal Degrees To Hours Minutes Seconds" Convert a decimal number of hours into number representing Hours, Minutes, and Seconds. Converts 12.5824388 hours into 12.345678 (representing 12h 34m 56.78s).

Double To Date Time Function

Converts the floating-point number of days since 12/30/1899 00:00 into a Date/time value. This is different that using the CDate function to convert a Double to a Date because of the way that Microsoft represents pre-1900 dates. Inverse of the DateTimeToDouble function.

Easter Function

Returns the day on which the Christian religious holiday Easter occurs given the year.

End Of Add Months Function

Return the last day of the month after adding a number of months to the given date.

End Of Add Months Test Sub

Compare the EndOfAddMonths function to Excel's EOMONTH function.

First Business Day Of Month Function

Returns the first weekday in the month given a date value. Same as FirstWeekdayOfMonth, but accepts arguments differently.

First Day Of Month Function

Returns the first day in the month given a date value.

First Day Of Period Function

Return the first day of the period (for example, the first day of the quarter), given a date within the period and the number of periods per year.

First Day Of Week Function

Returns the first day of the week (the first Sunday) for the given date. Returns vDate if it is already the first day of the week.

First Day Of Week In Month Function

Returns the first day of the week (for example, the first Tuesday) in the specified month.

First Weekday Of Month Function

Returns the first weekday of the month, with the weekdays considered Monday through Friday. Same as FirstBusinessDayOfMonth, but accepts arguments differently.

HMS To Decimal Function

"Hours Minutes Seconds To Decimal Degrees" Convert number representing Hours, Minutes, and Seconds into a decimal number of hours. Converts 12.345678 (representing 12h 34m 56.78s) to 12.5824388

Is Leap Year Function

Return true if the year is a leap year, meaning that it has 29 days in February and 366 days altogether.

Is Leap Year Test Sub

Test the IsLeapYear function to see if it agrees with an alternate method of calculating whether years represent "leap years."

Leap Years Verify Sub

Print the leap years, according to Microsoft.

Is Weekday Function

"Is Date A Weekday" Return True if a date is a weekday such as Monday, Tuesday, Wednesday, Thursday, or Friday.

Is Weekend Day Function

"Is Date A Weekend Day" Returns True if a date is a weekend day such as Saturday or Sunday.

Julian Date Function

Return the Julian Date given a year, month, and day of month. Similar to the JulianDay function, but correctly handles pre-1752 dates.

Julian Day Function

Returns the Julian Day corresponding to a date/time value. Similar to the JulianDate function, but does not correctly handle pre-1752 dates since it is based upon Microsoft's date functions.

Last Business Day Of Month Function

Returns the last weekday in the month given a date value. Same as LastWeekdayOfMonth, but accepts arguments differently.

Last Day Of Month Function

Returns the last day in the month given a date value.

Last Day Of Period Function

Return the last day of the period (for example, the last day of the quarter), given a date within the period and the number of periods per year.

Last Day Of Week Function

Returns the last day of the week (the Saturday) for the given date. Returns vDate if it is already the last day of the week.

Last Day Of Week In Month Function

Returns the last day of the week (for example, the last Tuesday) in the specified month.

Last Weekday Of Month Function

Returns the last weekday of the month, with the weekdays considered Monday through Friday. Same as LastBusinessDayOfMonth, but accepts arguments differently.

Moon Phase Function

Returns the phase of the moon as a number between 0 and 7. Use the MoonPhaseName function to determine the name for the moon phase.

Moon Phase Name Function

Returns the name of the moon phase given its number between 0 and 7. Use the MoonPhase function to determine the phase of the moon for a given date.

Next Day Of Week Function

Returns the date of the next specific day of the week (for example, the next Saturday).

Next Day Of Week On Or After Function

Returns the date of the current or next specific day of the week (for example, the current or next Saturday). Function returns the date component of vDate if it is the same day of the week as vDayOfWeek.

Next Weekday Function

Returns the next weekday (Monday through Friday) after the specified date.

Now Timer Function

Similar to the built-in Now function except accurate to 1/18 second.

Now Unique Function

Return the current date and time accurate to 1/18 of the a second. Forces the Microsoft Access Query optimizer to execute this function call for each row of the SQL UPDATE statement in which it is normally used; see below.

Now Unique With Sleep Function

Return the current date and time accurate to 1/18 of the a second, then sleep for 1 (one) second. Forces the Microsoft Access Query optimizer to execute this function call for each row of the SQL UPDATE statement in which it is normally used; see below.

Nth Day Of Week In Month Function

Returns the Nth day of the week (for example, the second Tuesday) in the specified month.

Number Work Days Function

Determine the number of business days between two dates, taking into account holidays that fall between the two dates.

Number Work Days Test Sub

Compare the NumberWorkDays function to Excel's NETWORKDAYS function.

Parse Date Time Function

Uses a date/time Format to parse the date and/or time components from a String, then returns the value as a date/time.

Previous Day Of Week Function

Returns the date of the previous specific day of the week (for example, the previous Saturday).

Previous Day Of Week On Or Before Function

Returns the date of the current or previous specific day of the week (for example, the current or previous Saturday). Function returns the date component of vDate if it is the same day of the week as vDayOfWeek.

Previous Weekday Function

Returns the next weekday (Monday through Friday) after the specified date.

Season Name Function

Returns the name of the season corresponding to the given date. Season differs depending upon whether location is Northern Hemisphere or Southern Hemisphere.

Ship Bells Function

Returns the number of ships bells to be rung at the given time, or zero for none. Ships rings their bells at half-hour intervals. For all other times, this function returns 0 (zero).

Weekday Fm String Function

"Weekday Number From Name" or "Weekday Name To Number" Convert a string naming a day of the week into a numeric constant. Return the vb numeric value corresponding to the named day of the week.

Weekday Month And Day To Matching Years Function

Takes part of a date such as Sun. Feb 15 along with a range of years, then returns a string containing the years in which that date is valid.

Weekday To String Function

"Weekday Number To Name" or "Weekday Name From Number" Convert a number representing a day of the week into the name of the day. Accepts one of the vb constant values which represent the days of the week.

Unique Years Verify Sub

Print the years which have fewer than 365 or more than 366 days (counting from Jan. 1 of the year to Jan. 1 of the next year).

Work Days Function

Add a number of business days to a date, taking into account holidays. Similar to the AddBusinessDays function, but takes into account holidays, and slightly different when vDate is on a weekend.

Work Days Test Sub

Compare the WorkDays function to Excel's WORKDAY function.

Year Fraction Function

Return the fractional part of the year (or years) between two dates, according to the specified day count basis.

Year Fraction Test Sub

Compare the YearFraction function to the Excel's YEARFRAC function.

Zodiac Function

"Date To Zodiac Name" Returns the name of the Zodiac sign given a date.

Zodiac Sample Sub

Print the boundaries of the Zodiac signs. Also serves as a sample of the Zodiac function.

This Windows-based ActiveX DLL provides many useful routines through its function-bearing and data structure classes. Consult the Help file for more information, or call us at 1-310-472-3736. For the latest news and files, visit our home page on the World Wide Web: http://www.entisoft.com