Find my week spot...

[The Headache]

Hi

I have a "recDate" date field. If I know a specific date how would I go about finding the records that are in the week containing THAT date in a script?

So if I know 6-24-09, I would like to find 6-22-09...6-26-09 (mon-fri).

Thanks in advance. You guys are great!

PS: I am at work on XP and FM 8.5 Advanced

[The Headache]

Thanks LaRetta

In setting up the script I ran into a snag with the SetField calc. I get an "operator expected here" right after the 1st instance of my date field.

Table = Processing

Date Field = B_Date Received

This is what I have...

Processing::_Date Received[color:red](operator expected here); Let ( date = Processing::_Date Received - DayOfWeek (Processing::_Date Received ) + 2 ; date & ".." & date +4 )

Did I miss (mess) something?

(Also for clarity for future readers I added a "." to the "..")

[The Headache]

No Problem. I get the date from one of the records so there would always be at least one. But I do see what you mean. Thanks for the thorough answer.

BTW, on efficiency:

An efficiency expert, concluded his lecture with a note of caution. "You need to be careful about trying these techniques at home. "

"Why?" asked somebody from the audience.

"I watched my wife`s routine at breakfast for years," he explained. "She made lots of trips between the refrigerator, stove, table and cabinets, often carrying a single item at a time.

One day I told her, `Why don`t you try carrying several things at once?`"

"Did it save time?" the guy in the audience asked.

"Actually, yes," he replied, "It used to take her 20 minutes to make breakfast. Now I do it in seven."

Have a GREAT weekend!