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
