Jump 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.

search/find within a given date-range.

  •
dervaish
in Finding & Searching

Featured Replies

hello

once again i need your expert help to sort out this issue. i have a table which store appointments for patients. a patient can have more than 1 appointments. so my problem is that i want to find and display only those records where appointments are within a range of 7 days [7 days from today] so that the person who logs into the system can view the list and then call the patients to remind them about their upcoming appointments in the next 7 days. this range will never exceed 7 days and will always be 7 days from today. so all i want is to filter out and show [omit all others] a list of records that have appointments coming up in the next 7 days only.

so how can i accomplish this?..script or no script...doesn't matter.

thanx in advance.

The script could look something like...

Go to Layout (the layout that you want your user to see/print)

Enter Find Mode

Set Field [Date ; Get(CurrentDate) & "..." & Get(CurrentDate) + 7 ]

Perform Find

Sort Records

  • Author

thanx for the quick reply and help. i'll try it out later.

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

Account

Navigation

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.