Version 2.1 Build 208

<--

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

Copyright 1996-1999 Entisoft

Entisoft Tools is a trademark of Entisoft.