twilkins

Cory,

I am interested in this macro if you can find it.

Thanks

See attached sample macro. It prompts the user for DOB, then calculates age and displays in notepad.

calculate_age_from_DOB.mex

this is the logic to compute the age. Today's date minus date of birth = xxxx days divided by 365.25 (accounts for leap year) to calculate age in years. Any suggestions on how to make this work in MEP?

Thanks for your suggestions. Everything works. I will keep looking for a way to compute (in MEP) age based on date of birth.

I need to process a text file to extract (example below) patient name, medical record number (MRN), DOB (convert DOB to age), and gender. The file will have a variable amount of patients per day. I need to then paste these variables into a new text file. Any suggestions?

As of: 09/14/09 08:22 Page 1

S C H E D U L I N G M A N A G E M E N T

Non-worksheet Daily Summary

Resource: DOC

Date: 09/14/09

Time Dur Appointment Type State Requester

09:00 20 RETURN PATIENT VISIT Confirmed

Person: DOE, JOHN

Home Phone: (706) 788-8888 MRN: 001234567 DOB: 08/09/1965 Gender: Male

Reason: HEALTH MAINT

09:15 20 RETURN PATIENT VISIT Confirmed

Person: DOE, JANE

Home Phone: (803) 688-8888 MRN: 007654321 DOB: 12/22/1954 Gender: Female

Reason: health maint

09:20 20 RETURN PATIENT VISIT Confirmed

Person: DOE, BROTHER

Home Phone: (803) 666-6666 MRN: 001111111 DOB: 09/04/2007 Gender: Male

Reason: 6 MOS CHECK

09:30 20 RETURN PATIENT VISIT Confirmed

Person: DOE, SISTER

Home Phone: (706) 999-9999 MRN: 002222222 DOB: 09/27/2008 Gender: Female

Reason: HEALTH MAINT

*** End of 09/14/09 appointments ***

* ** E N D O F R E P O R T * * *