Use a title macro in your NPR along with a MIS.GL.PERIOD loop to figure out the end of month date for whatever month you are doing it for, to default in your report selection criteria. No messy vb coding to figure out dates and whatnot, plus you can easily view the NPR selection criteria for figuring out download dynamic filenames based on dates.
There are Meditech.com knowledge base articles regarding figuring out end of month dates using MIS.GL.PERIOD and kb articles regarding title macros used to default selection criteria. Thank you, Mitch Lawrence Lead Applications Analyst Technical Support - NPR/Automation CHRISTUS Information Management *: [email protected] <mailto:[email protected]> Send a "thank you <http://intranet.christushealth.org/spiritBuck/Default.asp> " to someone! ________________________________ From: [email protected] [mailto:[email protected]] Sent: Thursday, May 14, 2009 9:14 AM To: [email protected] Subject: [talkbws] NPR Report date parameters ? Good morning... I have a script that will run an NPR report that once completed will run on the 1st and 15th of every month. I need the script to be able to evaluate what day is it running and based from that, input either the 1st day of the month (05/01/09) to the 15th day of the month (05/15/09) if it's being run on the 15th OR input the 16th (05/16/09) and the last day of the month (05/31/09) which of course will change month to month depending on what month it is if it's being run on the 1st of the month... I'm kind of at a loss on how to accomplish this...Anyone will to share their thoughts or ideas on it? Thanks! Travis D. Hanson, Application Analyst Anderson Hospital 6800 State Route 162 Maryville, IL 62062 618.288.5711 ext 5862 [email protected] --- To post a message to this list, send mail to: [email protected] You are currently subscribed as: [email protected] Unsubscribe in the customer center on our website: http://www.bostonworkstation.com/customer_center/virtual_user_group_talk .aspx
<<image001.jpg>>
