**Procedure Name** |
**Description** |

AddDays |
Add or subtract a number of days to a date |

AddMonths |
Add or subtract a number of months to a date |

AddWeekdays |
Add or subtract a number of weekdays to a date. Weekend dates are not counted in adding/subtracting days. |

AddWeeks |
Add or subtract a number of weeks to a date |

AddYears |
Add or subtract a number of years to a date |

AgeCalc |
Get the age in years and weeks for the supplied birthday |

AgeYears |
Get the age in years for a specified birth date |

AgeYearsFractional |
Get the exact age in years with decimals |

DayOfWeekName |
Get the day of week name for any date |

DaysInMonth |
Get the number of days in a month |

DiffDatesFormatted_
CalculatedByCalendar |
Get the number of Years, Months, Days, Hours, Minutes,
and Seconds between two dates based on calendar days |

DiffDatesFormatted_
CalculatedBySecondsPerYear |
Get the number of Years, Months, Days, Hours, Minutes, and Seconds
between two dates based on seconds |

DiffDays |
Get the number of whole days between two dates. The date is rounded down (it takes 24 hours to make a day). |

DiffDaysFractional |
Get the number of days (including fractions) between two date/time values |

DiffMinutes |
Get the number of whole minutes between two date/time values. Minutes are rounded down (must have 60 seconds to count as a minute). |

DiffMinutesFractional |
Get the number of minutes (including fractions) between two date/time values |

DiffMonths |
Get the number of whole months between two dates.
Second date's day must be >= first date's day to be considered a full month. |

DiffSeconds |
Get the number of seconds between two dates/times |

DiffTime |
Get the difference in hours, minutes, and seconds between two times (date portions are ignored) |

DiffWeekdays |
Get the number of weekdays between two dates. The days are rounded down (it takes 24 hours to make a day). |

DiffWeeks |
Get the number of whole weeks between two dates. The week is rounded down (it takes 7 whole days to make a week). |

FirstDayOfWeek |
Get the first day (Sunday) of the week of a given date |

Get4YearShortDate |
Get a date string that displays the full date and 4 digit year based on the user's windows settings. |

GetDatePart |
Get the specific portion of the date requested. |

GetRandomDate |
Get a random date between the range of dates |

IsLeapYear |
Determines if the year is a leap year using the internal DateSerial function. |

IsLeapYear2 |
Determines if the specified year is a leap year, using simple comparisons to determine leap years without relying on the DateSerial method. |

LastDayOfWeek |
Get the last day of the week (Saturday) of the supplied date |

LastDayOfWeekInMonth |
Get the last day (Sunday, Monday, etc.) of the month |

MonthFirstDay |
Get the date of the first day of the month |

MonthFirstWeekday |
Get the first weekday of the month (first day of the month that is not a Saturday or Sunday) |

MonthLastDay |
Get the last day of the month |

MonthLastWeekday |
Get the last weekday of the month (last day of the month that is not a Saturday or Sunday) |

NextDate |
Increment a date by 1 day |

NextDOW |
Get the specified day of the week after the given date |

NextWeekday |
Calculates the next weekday (skips weekend dates). Date returned is always between Monday and Friday. |

NthDayOfMonth |
Get the date of the Nth day (Monday, Tuesday, etc.) of the month |

PriorDate |
Decrements the passed date by 1 |

PriorDOW |
Get the specified day of the week after the given date |

PriorWeekday |
Get the previous weekday (skips weekend dates) |

QuarterFirstDay |
Get the first day of the quarter for a given date. Quarters start at the beginning of January, April, July, and October. |

QuarterLastDay |
Get the last day of the quarter for a given date. Quarters end at the end of March, June, September, and December. |

WaitForTime |
Waits until the specified date and time |

WaitSeconds |
Waits for a specified number of seconds |

WeekNumber |
Get the week number as defined by the format command
which counts Jan 1 as week 1 |

WeekNumberFirstDayOfYear |
Get the first day of the specified year using ISO 8601
week definition |

WeekNumberStandardized |
Get the week number for a specific date using ISO 8601
guidelines |

WeekNumberStartJan |
Get the week number where 1 is the week including Jan 1
and end of year dates are week 1 of the following year |