Search by date

[kiyokai42]

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

[LiveOak]

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

[kiyokai42]

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.

[jfrick]

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 "..."?

[jfrick]

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.