Search ...

781.329.4300 ¦ Message us ¦ Customer support login ¦ Product documentation

Services
Custom reporting
Data integration
DR support
EHR conversion
Expanse migration
Staff augmentation
Quality
Quality Services
Chart Abstracted Measures
Mapping Services
Quality Resources
Solutions
Downtime Defender
Empower
OneLink
Partnership program
Power BI
ViewPoint
The Hub
Advisor
DR Network
Events
News
Education
Live online classes
MUSE Conference
Power BI training
Training videos
About
About us
Careers
How we work
Our team
Contact

You are here:
Home
DR Network
TSQL code
Age intervals (function)

Welcome to the DR Network.

Everything you need to get started building reports with Data Repository. All free and available for every MEDITECH version from MAGIC to Expanse. Sign up today!

Your name*

Your email address*

MEDITECH version

MAGIC

C/S

6.0x

Expanse

Your organization

I'm interested in learning more about (select all that apply)*

Empower or Power BIDowntime DefenderQuality servicesCustom reports

DR supportData integrationOther

Age intervals (function)

TSQL code

MT platform: All

This table-valued T-SQL function returns date interval/period calculations that can be used to assemble age or any elapsed time string. (Read our blog for more information about user-defined functions in T-SQL.)

To download this report, please log in or create an account. →

fn parse mt name