Skip to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Finding records using Account name and date ranges

Featured Replies

Hi, after all, I'm here again, asking your help...

I have a database with account names and dates and hours.

Every day I create a new record putting the current date and hour to control the time of one person that have one account name.

But I have to make a report and I want to view only records of one Account Name (example: Everton) and all dates that I've been inserted by using date ranges.

Like this:

Account: Everton

StartDay: 08/02/2006

EndDay: 10/02/2006

FIND

By clickin in find, this will return all records like this:

Everton - 08/02/2006

Everton - 09/02/2006

Everton - 10/02/2006

I have writen this script:

Enter Find Mode[]

Insert Calculated Result [select; GetAsText (Database::StartDay) & "..." & GetAsText (Database::EndDay)]

Perform Find []

I need the part of the script that returns only records from user "Everton"...

Can you help me please???!!!!

Thank you very much...

Read this:

http://www.filemaker.com/help/Script-Steps71.html

--sd

Why use Constrain, when it can be done all in one stage:

Enter Find Mode [ ]

Set Field [ Date ; gStartDay & ".." & gEndDay ]

Set Field [ Account ; gAccount ]

Perform Find [ ]

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.