Constrain data using a date range

[Wayne0412]

Hello,

Can someone please please please help me. If I had hair I would be pulling it out right about now!!!

I have a succesfuly written a script which constrains a set of data to one particular order type IE: Quote from four possible order types (Quote, Invoiced, Reservation and Hold). That part was easy.

Now I want to further constrain that list to those orders that fall within a date range, specifically from Today's date to Today's date plus seven, basically omitting records which fall outside that date range.

I need to be able to do this from within a script, with no user input, and without dialogue.

Essentially what I am trying to do is produce six different reports from one set of master data and have the user press one button to populate and sort all of the reports.

If I could get this date range thing sorted, the rest of the reports would be easy to do.

Please help, I am desparate!!

Cheers

[comment]

Try:

Enter Find Mode []

Set Field [ YourTable::Datefield ; Get (CurrentDate) & "…" & Get (CurrentDate) + 7 ]

Constrain Found Set []

[Wayne0412]

Try:

Enter Find Mode []

Set Field [ YourTable::Datefield ; Get (CurrentDate) & "…" & Get (CurrentDate) + 7 ]

Constrain Found Set []

Brilliant, works like a dream, thank you so much.

I spent about six hours trying to get that to work!!!

[comment]

It's all here:

http://www.filemaker.com/11help/html/find_sort.5.8.html#1028153