Hi David, The following is a piece of code that will give you the GL Period for a given date. Set the date of interest to the variable ZDATE. The Period will be returned as the variable ZPERIOD
"20070120"^ZDATE, ZDATE^MIS.GL.PERIOD.ending.date, @Next(MIS.GL.PERIOD.ending.date,MIS.GL.PERIOD.date.x), MIS.GL.PERIOD.date.x[MIS.GL.PERIOD.ending.date]^ZPERIOD In this example, ZPERIOD is "Jan 2007" Let me know if you have any questions. I will be glad to help. In case anyone might need this in the future, I put two versions of this code on the meditech-l WIkiPedia at http://MTUsers.net/mwiki Gil Arnold Interface People, LP Office: 214-222-1125 ext. 252 [EMAIL PROTECTED] http://www.ipeople.com ________________________________ From: [EMAIL PROTECTED] on behalf of Gibbs, David Sent: Wed 7/11/2007 1:04 PM To: [email protected] Subject: [MEDITECH-L] Determining period a date belongs to in NPR macro Hi I am trying to figure out a way to determine what GL period a date belongs to in a macro. Before I spend a lot of time inventing the wheel, I thought I would check to see if someone else has already determined it. My selects are Xx.fromperiod ig From Period Xx.thruperiod ig Thru Period Enter.date ge /FROM Enter.date le /THRU I have a start macro that assigns /FROM and /THRU and an ID attribute on xx.fromperiod to look up the GL period I want to evaluate each record to determine which period @enter.date is in. The logic I think I want (but I get mixed up with the syntax of the DO loop in my macro) is like this: >From StartPeriod to EndPeriod set variable for previous period if enter.date > previous period end date AND enter.date < current period end date then Set variable to capture the current period Loop I know I need the fields to do this MIS.GL.PERIOD.period MIS.GL.PERIOD.ending.date[period] enter.date is a field in my Report DPM (it has DATE datatype) Can someone help me to put this logic into Magic syntax? Thanks David Gibbs Lab IS Analyst Fraser Health =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= To subscribe or unsubscribe to the meditech-l, visit http://mtusers.com/mailman/listinfo/meditech-l_mtusers.com To check the status of the meditech-l, visit MTUsers.NET For help, email [EMAIL PROTECTED] Please visit and add information to the MTUsers WikiPedia at MTUsers.NET/mwiki ______________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l_mtusers.com
