I have created a small time sheet database in Filmaker. I have created a second database that in theory, should allow a person to compare time work to time billed. I have that figured out, but I don't know how to tell filemaker to narrow the search between a start date and a end date.

Thank you for your help

MuD

You are going to have to restate the question, it's not clear what you mean by "narrow the search between start date and end date".

-bd

I want to get a report on how many hours a person worked from the 3rd of December to the 7th of December. I can get the total hours they worked so far, no problem, but I can't narrow that information to a specific start and end time.

I hope that is a bit clearer.

M.D.

Sorry this isn't an answer but a simular question. Is it possible to do a date range find using a script? What am I doing wrong?

Enter Find Mode

Set Datefield [gBeginDate & "..." & gEndDate]

Perform Find

I've tried the set command separately and it doesn't recognize the "..."?

I solved my problem and maybe this will help you.

Enter Find Mode

Set Field [Date, gBeginDate]

Insert Text [Date, "..."]

Insert Calculated Result [Date, EndDate]

Perform Find

That's how you find a date range using a script.