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

Hi Marita,

Here is one way to do it:

1)      Create an xx field called xx.days.since.last.run with the following 
attributes:

DAT=PINT
LEN=2
VAL=IF{"MIS SCHED MNEMONIC"^MIS.JOB.mnemonic,
VAL=%Z.link(":","MIS","%.MIS.data","MIS")^OLD,
[EMAIL PROTECTED],
VAL=ZZ%O(:,OLD),
VAL=%Z.date.sub(@.today,LRD)}
WITH=START

This VAL attribute connects to your MIS data and stores the last run date in 
the local variable called LRD.  It then calculates the number of days from then 
to the current date.  You will need to replace "MIS SCHED MNEMONIC" with the 
name of your MIS schedule mnemonic.

2)      Use xx.days.since.last.run as Select Field with the Operator GT and the 
value "7"

Using the WITH=START Field Attribute will instruct your report to calculate 
this value at the start of the report.  It will not run if the number of days 
since your report last ran is not greater than 7.

Please let me know if you have any questions.

Good luck,

Brian Schmit
Sr. Programmer, Picis
Direct: 781 557 3315
Fax: 781 557 3140
100 Quannapowitt Parkway
Suite 405
Wakefield, MA 01880
[EMAIL PROTECTED]
www.picis.com

Please visit www.picis.com/meditech for additional information about our NPR 
Report Writing Trainings.

The information in this email is confidential and may be legally privileged. It 
is intended solely for the addressee. Access or use by any other person to this 
internet email is not authorized and may be unlawful. If you are not the 
intended recipient, please delete or destroy this email. If you do not wish to 
receive future emails from the sender, please reply directly to this email 
requesting you be removed from any mailing list.






-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Ward, Marita
Sent: Thursday, July 06, 2006 3:00 PM
To: [email protected]
Subject: [MEDITECH-L] Scheduling jobs to run biweekly


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


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

Reply via email to