That Time Of The Month

[snuggster]

i have a cloth inventory file im working on, and we need to report consignment to our suppliers, but i need to find only the pieces the lay within the first day(sunday) of the third week in the previous month to the last day(saturday) in the second week of the current month.

confusion help me!

-Snuggster

[ January 18, 2002: Message edited by: snuggster ]

[Garry Claridge]

Here are two calculated fields I have used to find the first day (Sun) of the third week of the current month.

first_day:

DayofWeek(Date(Month(Today),1,Year(Today)))

start_day:

Date(Month(Today),(8 - first_day + 8),Year(Today))

You can expand on these to give your exact requirements. Then you can use these calculations in a script for finding the required records.

All the best.

Garry

[ January 18, 2002: Message edited by: Garry Claridge ]