Title

multiple dates in Find mode

Post

Hello all:

newby question here...

I want to find records within a time spread of a year. I have been trying to follow the FTS chapter on finding records, and I can see what you input into your date field, but the search does not yield what I would like. I also have tried writing a script, but have yet to master that skill.

So, the Find in the date field seems to be the easiest thing to try, can some one please explain that to me??

Enter Find mode, go to the date field, enter the start date then three dots then the end date. This is how to find a range of dates.

If you want to multiple specific dates: enter find mode, go to date field and enter one date, then still in find mode create a new find request (cmd N) enter in next date, continue like this so that you have multiple find requests, then click find.

Is the data you are searching displayed in a portal (that's what it sounds like), or directly in a layout.

If your records are listed in a portal, set up a layout based on the portal records and search it, specifying the date range just as alan subscribed.

Depending on the way you've structured your records, you may need to set up a summary report with a sub - summary part sorted to group the records by person with a summary field computing the total hours for each.