All messages should be posted in plain text.  HTML will be converted to
attachments.    The meditech-l web site is MTUsers.com
======================================

Do this in your computed field

DAT=INT
LEN=10
VAL=%Z.date.out(@your.field.here,"",10)

When doing a download, the RW puts quotes (a/k/a "text qualifiers")
around all non-numeric fields.  To get it to stop, you need to define
the field as a numeric type.  Then you have to do the conversion to
MM/DD/YYYY (DD/MM/YYYY in CA) with Z.date.out

 


Joe Cocuzzo
Vice President
NPR Services
Iatric Systems, Inc.
Phone/Fax: (978) 805-4115
Email: [EMAIL PROTECTED]
Web: www.iatric.com


-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Renee Rinehart
Sent: Wednesday, August 02, 2006 4:55 PM
To: [email protected]
Subject: [MEDITECH-L] Magic computed field help with date

All messages should be posted in plain text.  HTML will be converted to
attachments.    The meditech-l web site is MTUsers.com
======================================

In this computed field, I've used DAT=DATE10 and the date is fine other
than when I download the report, I have quotation marks around the date.
Example..."07/31/2006".  How do I strip the quotes from my output?
Thanks for any help. 

Renee' Rinehart, HCIS Financial Coordinator Guadalupe Regional Medical
Center Seguin, Texas  78155
830-401-7214
[EMAIL PROTECTED]

_______________________________________________
meditech-l mailing list
[email protected]
http://mtusers.com/mailman/listinfo/meditech-l

_______________________________________________
meditech-l mailing list
[email protected]
http://mtusers.com/mailman/listinfo/meditech-l

Reply via email to