[MT-L] NPR - format date - MAGIC

[Laurie Beffa]

Struggling with reformatting a date.
Report is written in BAR.PROC
Detail segment: bar.proc.dict
Field to format: std.effective.date
Data pulls to report as ex. "10/01/10"
Desired output is: no text qualifiers, MMDDYYYY

Have tried every combination found on the L and with Meditech's Help
files. All computed fields have resulted in no data being populated.
Meditech support has yet to present a solution.

Any ideas??

Thanks!

--
Laurie Beffa
Mercy Regional Health Center
Manhattan, KS

====================================

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.

To UNSUBSCRIBE or to SUBSCRIBE, go to http://MTUsers.net for information.

You can locate the:
1) meditech-l archives
2) NPR/Magic/CS tips
3) job opportunities in the Meditech community
http://mtusers.net

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.

[Brian Golden]

Laurie,

Please try the following; Create a custom field of
xx.std.effective.date.

DAT=FREE
LEN=8
VAL=%Z.date.text(@std.effective.date,"NDY")

Please let me know if it provides the results you are asking for.

Brian

Any ideas??

Thanks!

====================================

-----------------------------------------
The materials in this e-mail are private and may contain Protected
Health Information. If you are not the intended recipient, be
advised that any unauthorized use, disclosure, copying,
distribution or the taking of any action in reliance on the
contents of this information is strictly prohibited. If you have
received this email in error, please immediately notify the sender
via telephone or by return e-mail.

www.southeastmissourihospital.com

[Laurie Beffa]

Thank you for everyone's help with this computed field. This is what
finally worked:

DAT=INT
JFY=R
LEN=8
VAL=%Z.date.text(-...@std.effective.dates[@mnemonic,@.today+1],"NDY")

On Fri, Oct 8, 2010 at 1:14 PM, Richard Serrano <res...@gmail.com> wrote:
> Hello
>
> Try in a computed field:
>
> xx.sed
>
> DAT=DATE
> LEN=8
> VAL=@std.effective.date%3_(@std.effective.date:4T)
>
> Thanks
> Richard Serrano
> NPR Consultant
> Iatric systems

[Jeff Lee]

Will "@.today+1" work for you consistently (e.g. at change of month and year)? I had @.today+1 on some of my early reports and eventually discovered it didn't work. Now I use the %Z programming for adding

%Z.date.add(@.today,1)

Jeff Lee
Assistant Director of Pharmacy, Support Services
DCH Regional Medical Center
809 University Blvd E.
Tuscaloosa, AL 35401

(205) 750-5323
jl...@dchsystem.com

The information contained in this e-mail message is confidential information intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient or the employee or agent responsible to deliver it to the intended recipient, the reader is hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.

-----Original Message-----
From: meditech-...@mtusers.com [mailto:meditech-...@mtusers.com] On Behalf Of Laurie Beffa