You can select on ccdqr.date EQ
Date TODAY-1
Or
ccdqr.date EQ
(%Z.date.add(/.DAT,"-1"))
or
ccdqr.date EQ
(%Z.date.add(@.today,0-1))
------------------------------------------------------------------------
-------------------------------
In NUR I use this in the selects on page 2 of the report.
NUR.PC.WORK.zcus.bm.rt.worklist
String Found: Z.date.add
Selects:
td.act.date GE (%Z.date.add(@.today,0-2))
------------------------------------------------------------------------
-------------------------------
OE.ORD
OE.ORD.zcus.bm.rt.frag2
String Found: Z.date.add
Selects:
service.date GE (%Z.date.add(@.today,0-3))
________________________________
From: meditech-l@MTUsers.com [mailto:[EMAIL PROTECTED] On Behalf
Of Sanchez, Teresa
Sent: Wednesday, May 16, 2007 5:28 PM
To: Meditech-L@MTUsers.com
Subject: [MEDITECH-L] Computed field NPR help
Hello,
I have written a report in NPR in the ADM.PAT detail dpm and have a
computed field for an NUR query as:
xx.wt
DAT=FREE
JFY=L
LEN=3
[EMAIL PROTECTED]"NUR.LB"]
Which prints the last value just fine but
is it possible to create another computed field to get yesterday's
value? (T-1)
Teresa Sanchez
Systems Analyst
Little Company of Mary Hospital
310-792-7623
DISCLAIMER:
This message is intended for the sole use of the addressee, and may
contain information that is privileged, confidential and exempt from
disclosure under applicable law. If you are not the addressee you are
hereby notified that you may not use, copy, disclose, or distribute to
anyone the message or any information contained in the message. If you
have received this message in error, please immediately advise the
sender by reply email and delete this message.
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed.
This footnote also confirms that this email message has been swept by Sophos
and MIMEsweeper for the presence of computer viruses.
**********************************************************************
QUERYDATE.npr
Description: QUERYDATE.npr
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= To subscribe or unsubscribe to the meditech-l, visit MTUsers.NET. To check the status of the meditech-l, visit MTUsers.NET. For help, email [EMAIL PROTECTED] Visit the MTUsers WikiPedia at MTUsers.NET/mwiki ______________________________________ meditech-l mailing list meditech-l@MTUsers.com http://mtusers.com/mailman/listinfo/meditech-l
