I believe that would give you the period PRIOR to the period your date was in.
Replace your minus with a plus. Thank you, Mitch Lawrence Lead Applications Analyst - Advanced Report Writer General Financials Support CHRISTUS Information Management ': 361.881.3408 7: 361.888.6117 È: 361.549.8456 )AIM: a1d13 )MSN: [EMAIL PROTECTED] : [EMAIL PROTECTED] Send a "thank you" to someone! -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MacPherson, Ken R. Sent: Thursday, July 12, 2007 6:18 AM To: Gibbs, David; [email protected] Subject: Re: [MEDITECH-L] Determining period a date belongs to in NPR macro Hi David; Actually, to determine the date a period belongs to works like this. The date must be in YYYYMMDD format. Assume the date we are trying to find the period for is in c.date. Then the following should work IF{MIS.GL.PERIOD.date.x[c.date]; -MIS.GL.PERIOD.date.x[c.date]^DT, MIS.GL.PERIOD.date.x[DT]; "NOT FOUND"} Substitute in whatever you want for the NOT FOUND result. This would occur if you enter a date prior to the start date for the first period set up in your system. Hope this Helps Ken -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gibbs, David Sent: Wednesday, July 11, 2007 2: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 =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= 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
