All messages should be posted in plain text. HTML will be converted to
attachments. The meditech-l web site is MTUsers.com
======================================
So @time.queued is the date field in the internal format that you would
like your 'T-nn' ( @.today minus number of days) to be compared to, yes?
Have you thought about setting up a /SLASH variable via in a macro,
calling the macro at the start of the report, and using the /SLASH
variable as a select on page 2 ?
The page 2 select would look like;
@time.queued GE /R.BEG.DATE
the footnote call on page 3 would look like;
AL START start.stuff
And the start.stuff macro would look like;
%Z.date.clinical(%Z.date.add(@.today,(0-1)))^/R.BEG.DATE
Good Luck!
Cris
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Paul MacDonald
Sent: Wednesday, May 31, 2006 5:13 AM
To: Meditech-L (E-mail)
Subject: [MEDITECH-L] MAGIC NPR: Formatting Internal Dates for Selection
All messages should be posted in plain text. HTML will be converted to
attachments. The meditech-l web site is MTUsers.com
======================================
Hello folks,
I'm having difficulty trying to get my NPR to allow me to select by an
internal date when I use the 'T-XX' format. I would like to schedule a
report to run based on a field that is in the internal date/time format
(seconds from 1 Mar 1980). I am using the following:
xx.date
DAT=FREE
JFY=L
LEN=10
VAL=%Z.date.clin.to.out(@time.queued)
When I try to use xx.date in my selection on page two, it doesn't
recognize the common format of 'T-XX' (i.e. it doesn't expand out to the
corresponding date), and no results are returned. If I type in the
actual dates (mm/dd/yy) and the report runs fine.
If I change xx.date to DAT=DATE, the 'T-XX' format expands out on the
screen, but I get no results this way either.
I would like to schedule this report to run on a daily basis, so I need
to have the 'T-xx/S' in order for it to work.
Any suggestions???
Paul MacDonald
Clinical Application Specialist
Civista Medical Center
8 Kent Ave, LaPlata, MD 20646
(w) 301-609-4490
(p) 301-396-0698
_______________________________________________
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
