Having troubles defining a script for finding and printing sales for the
month.
Thanks
Barry

Paragraph beginning "Re calculation" should read:

you get the first day of the last month by taking 1 from
the current month, setting the day to 1 and setting the year to the current
year (this will still work even if the current date is 1st Jan 2003 because
the date will look like 0/1/2003 which filemaker knows how to convert to
12/1/2002); you get the last day of the last month by setting the month to
the current month, setting the day to 1-1 and the year to the current year
(if the current date is 1st Aug 2003 that will produce 8/0/2003 which
filemaker converts to 7/31/2003, and again, this will also work if the date
is 1st Jan 2003 which will produce 1/0/2003 which filemaker converts to
12/31/2002)

Last day of previous month is day 0 of this month (not -1).

"Bridget Eley" <bridgeteley (AT) ihug (DOT) com.au> wrote

Sorry, didn't notice the "1-1" (which is the same as 0).

"Glenn Schwandt" <schwandtgat (AT) aoldot (DOT) com> wrote


<SNIP>

This is great.....I can't thank you enough for all the help given
Have a wonderful day
Barry


"Glenn Schwandt" <schwandtgat (AT) aoldot (DOT) com> wrote

From a performance point of view, I guess using 0 would be better (one less
thing to calculate) although in a script like this, I doubt it would make a
perceptible difference. Using 1-1 has one advantage though: it seems to say
what it means, "one day less than the first day", which is obviously the
last day of the previous month, which does makes the calc easier to
understand when you come back to it after a spell (whereas 0 is a little
more ambiguous).

The main point as far as Barry is concerned is that the calc works whether
you use 0 or 1-1 because Filemaker knows how to roll back the dates to the
previous month and/or year if the day and/or month are zero or even negative
values. So there is absolutely no need to wrestle with humungous calcs that
attempt to manually calculate the last day of a given month and where
necessary adjust the year, covering such variations as 31, 30, 29 and 28 day
months as well as months that fall in the previous year. Just wish someone
had told me that when I was starting out...

;-)

Bridget

in article vikrn9krslstc5 (AT) corp (DOT) supernews.com, Glenn Schwandt at
schwandtgat (AT) aoldot (DOT) com wrote on 1/8/03 11:45 PM:

When I know I have data that will need to be reported by Weekly or
Monthly I create the appropriate Calc-Field. I use SDATE as my
standard field name for Sales_Date. The Month field is
Year(SDATE)&right("0"&month(SDATE),2). This makes selecting records
for a particular month much easier. I do a similar calc for Week
numbers where I have a result of YearWk such as 200352.

Thomas Hill, CHAE, CHTP
Controller
Balcones Country Club


Bridget Eley <bridgeteley (AT) ihug (DOT) com.au> wrote