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
