Analytics services and solutions for MEDITECH.

This scalar TSQL function returns a computed age between two dates, shown to the nearest whole year.

This scalar TSQL function returns a computed age between two dates, shown in whole years and months (0Y 0M). Sometimes used for pediatric patients.

(Read our blog for more information about user-defined functions in T-SQL.)

This scalar TSQL function returns a computed age between two dates, shown in whole months and days (0M 0D), typically used for infants.

(Read our blog for more information about user-defined functions in T-SQL.)

This scalar TSQL function calculates the last second of a given day (23:59:59) when passed a date in mm/dd/yyyy format. Useful for getting to the end of a day on reports that prompt the user for a date range.

(Read our blog for more information about user-defined functions in T-SQL.)