[MT-L] Problem with date formats when downloading out of NPR
Derek L. Prim
Hello,
This is Derek Prim from Phelps Country Regional Medical Center. We are currently a MAGIC facility running 5.64 PP19. My cohort and I are attempting to download a report through NPR. All goes rather well until the time to import the file into excel. The problem we run into is when we look at the Birth Date. When viewing the report in NPR, it is seen in a YYYYMMDD format which is fine. However, when it is downloaded, the format changes to MM/DD/YY. While this normally wouldn’t be a problem, we have gotten to the point where we are dealing with elderly meaning that a birthdate of 1/1/11 could mean either 01/01/1911 OR 01/01/2011. Has anyone encountered this problem and is it possible to make Meditech spit out the format exactly as it is viewed before download?
As a side note, I opened the download file in notepad to see if the conversion was happening in excel when opening the file and I can confirm that it downloads as MM/DD/YY. We have also attempted making the field in NPR a BDATE10 and a DATE10.
Thanks,
Derek Prim, M.S. IST
Systems Analyst
Phelps County Regional Medical Center
CONFIDENTIALITY NOTICE: This e-mail communication and any attachments may contain
confidential and privileged information for the use of the designated recipients
names above. If you are not the intended recipient, you are hereby notified that
you have received this communication in error and that any review, disclosure,
dissemination, distribution or copying of it or its contents is disallowed.
If you have received this communication in error; please notify Phelps County
Regional Medical Center immediately by telephone at (573) 458-8899 extension
4357 and destroy all copies of this communication and any attachments.
James A Purvins
Jim Purvins
===###===###===###===###===###===###===
To unsubscribe from the meditech-l, follow the instructions at the URL http://mtusers.com/mailman/options/meditech-l_mtusers.com/
Please do NOT send messages that ask "Please post to the list" or "I'd like to see your answers" or "Send that info to me, too" These are useless messages that just waste the email server's resources. Instead, email the original requester and ask that they send you or post the results of their question.
Go to http://MTUsers.net for other information on the list, as well as:
1) reading meditech-l messages online
2) job opportunities
3) vendor products and service
Do NOT send email to meditech...@MTUsers.com. This is a system email box that is NOT monitored by a human. If you need help or advice on how to use the meditech-l, email lo...@MTUsers.com or ju...@MTUsers.net. Both of these people help manage the meditech-l, so they are your best resource.
===***===***===***===***===***===***===
Joy Merritts
Have you tried a computed field?
DAT=PINT
JFY=R
LEN=10
VAL=%Z.date.text(@date.of.birth,"N/D/Y")
Joy C. Merritts
Assistant I.T. Director
JC Blair Memorial Hospital
Warm Springs Avenue
Huntingdon, PA 16652
From: meditech-...@mtusers.com [mailto:meditech-...@mtusers.com]
On Behalf Of Derek L. Prim
Sent: Thursday, August 09, 2012 4:05 PM
To: 'medit...@mtusers.com'
Subject: [MT-L] Problem with date formats when downloading out of NPR
Hello,
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.
James A Purvins
Jim
Daniel Serradas
This field will output the date in YYYYMMDD format:
xx.date
DAT=FREE
JFY=L
LEN=8
VAL=(@date$4)_(@date$6%3)_(@date%5)
From: Derek L. Prim
[mailto:dp...@pcrmc.com]
Sent: Thursday, August 09, 2012
4:04 PM
To: 'medit...@mtusers.com'
Subject: [MT-L] Problem with date
formats when downloading out of NPR
Hello,