I'm trying to build and application that uses Month-to-Date and Year-to-Date accumulators. In the perfect world I would have the system detect when the month or year change and prompt the user to run a report and then code a routine to zero out the appropriate accumulators after the report was run.

In our imperfect world am I asking to much for the system to detect a change in month or year? If I'm not asking too much of the application, can you give me a hint as to where to start!

Thanks

Robert,

I'm trying to build and application that uses Month-to-Date and Year-to-Date accumulators. In the perfect world I would have the system detect when the month or year change and prompt the user to run a report and then code a routine to zero out the appropriate accumulators after the report was run.

I don't understand the question … however, this might help. To determine if two dates are in to different months/years:

function GetYear(Date)

return fmt(Date, "DJ4")1,4

function GetMonth(Date)

return fmt(Date, "DFS")1,2

function GetYearMonth(Date)

return fmt(Date, "DJ4S")1,7

So to compare if two dates are in different months:

if GetYearMonth(Date1) # GetYearMonth(Date2) then …

Hope it helps!

Cameron Purdy

info@revelation.com

On the create event of the login window check a parameter file. If the month is the same as last time continue. If not run the routine and reset the parameter file month. Include locking where appropriate…

amcauley@sprezzatura.com

Sprezzatura Ltd

World Leaders in all things RevSoft

I believe I can do exactly what I wanted to accomplish with a combination of the data from both of you.

Thanks again.

View this thread on the forum...