[MEDITECH-L] Change date format
Sandy Smallwood
I need advise/help on changing a date format. I have a macro in my npr
report (which I download into Excel) to list the birthdate which
outputs, as ex: 19260711 and I need 07/11/1926. I'm unsure how to
modify my macro to obtain this format or how to change in Excel,
everything I've tried has not been successful.
Any advise will be greatly appreciated and thank you in advance.
Sandy Smallwood
Business Analyst
Community Health Center Branch County
***********************************************************
This email message may contain information that may be privileged,
confidential, and exempt from disclosure. It is intended for use only by
the person to whom it is addressed. If you have received this message in
error, please do not forward or use this information in any way, and
contact the sender immediately.
Thank you.
Joe Cocuzzo
Joe Cocuzzo
Vice President
NPR Services
Iatric Systems, Inc.
Phone/Fax: (978) 805-4115
Email: mailto:Joe.C...@iatric.com
Web: http://www.iatric.com/
Iatric Systems is a leading provider of integrated software applications, interfaces and reporting solutions for hospitals and healthcare systems.
__________
Sandy Smallwood
Business Analyst
Thank you.
====================================
Please do NOT send messages that ask "Please post to the list" 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.
To UNSUBSCRIBE, go to http://MTUSers.net
for information.
The meditech-l archives (and other tips) can be found at
http://mtusers.net/zarchives
Job opportunities in the Meditech community can be found at
http://mtusers.net/zjobs
Curtiss, John L
In Excel, Format, Cell, Number, Custom, enter mm/dd/yyyy. Before you do
this click on date and see all the formats available to you. When
importing the date data you may have to tell it that this is a date and
that the format is yyyymmdd.
Go to Meditech web site, product and resource pages for npr, left hand
column. Look at the Z programs. Some are date specific. Z.date.out
for mm/dd/yy or Z.date.out.long for mm/dd/yyyy.
On the report picture change the field type to date will output it in
mm/dd/yy format. Change it to DATE10 to put output it in mm/dd/yyyy
format. The type is probably FREE now if it is giving you yyyymmdd.
Macro:
(@some.date.field%3$2)_"/"_(@my.date.field%5)_"/"_(@my.date.field$4)^MY.
OUTPUT.FIELD will also give give you mm/dd/yyyy
Good luck.
John Curtiss
Hutchinson Area Health Care
1095 Highway 15 South
Hutchinson, MN 55350
320-234-4967
320-234-4637 (fax)
jcur...@hahc-mn.org
-----Original Message-----
From: meditech-...@mtusers.com
[mailto:meditech-...@mtusers.com] On Behalf Of Sandy Smallwood
Sent: Wednesday, January 20, 2010 2:19 PM
To: medit...@mtusers.com
Subject: [MEDITECH-L] Change date format
Sandy Smallwood
Business Analyst
Thank you.
Hadidian, Ara
Then I paste the formula below and copy it down to give me the MM/DD/YYYY.
Im sure there are easier or quicker ways but I don't need this more than 4 times a year.
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
Ara H.
Information Services
Barlow Respiratory Hospital
(213) 250-4200 Ext 3176
AHad...@barlow2000.org
Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
-----Original Message-----
From: meditech-...@mtusers.com [mailto:meditech-...@mtusers.com] On Behalf Of Sandy Smallwood
Sent: Wednesday, January 20, 2010 12:19 PM
To: medit...@mtusers.com
Subject: [MEDITECH-L] Change date format
Sandy Smallwood
Business Analyst
Thank you.