Hi Fairborz, I would add a user-defined field called xx.month.of.next.friday with the following attributes: DAT=FREE LEN=2 VAL=%Z.date.add(@.today,7)^TEMP$6%3 WITH=START Then I would use xx.month.of.next.friday as a Select Field with the operator NE an the Value (@.today$6%3) Then I would schedule your report to run every Friday. That new field will only allow your report to run if the month of the next Friday is NOT equal to the month of the current Friday. The WITH=START Field Attribute forces this field to be evaluated at the start of your report, so it does not bother going through all of your other Select Fields. Please let me know if you have any questions. Good luck, Brian Schmit Interface People, LP Office: 214-222-1125 ext. 306 Mobile: 617-823-9326 [EMAIL PROTECTED] http://www.ipeople.com <http://ipterm1.ipeople.org/exchweb/bin/redir.asp?URL=http://ipterm1.ipeople.org/exchweb/bin/redir.asp?URL=http://www.ipeople.com> Hi,
Does anyone know how to schedule a report to print on last Friday of each month? I am able to print on monthly, every 3rd Friday but that date is not necessarily the last Friday of the month, each month. Thanks Fariborz Peyjam Project Manager Mount Sinai Hospital Chicago, IL Phone: (773) 257-5257 Fax: (773) 257-2268 email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= To subscribe or unsubscribe to the meditech-l, visit MTUsers.COM. To check the status of the meditech-l, visit MTUsers.NET. For help, email [EMAIL PROTECTED] ______________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l
