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.

Wildcard in date field?

Featured Replies

Does anybody know if it in any way is possible to define a wild card date, example: **.Nov.1980 for a record from November 1980 with unknown day?

If you're searching for a date, then use the range operator:

1/11/1980...31/11/1980

You may need a complex calc to determine which months have 28, 29, 30, or 31 days. Another approach is to make two Find requests. The first finds records from the first of the month to the first of the next month. The second request omits the first of the next month:

1/11/1980...1/12/1980

1/12/1980 (omit)

Create a calculation text field...

code:


MonthName (date) & " " & Year (date)

...and search on it using the format "November 1989"

  • Author

Yup, the idea of creating a copy as a text field is my solution at the moment. Here I use wildcards like this: If I know my record is from November 1980 but I do not know the exact date I file it as: **.11.1980 (we use the DD.MM.YYYY - format in Denmark).

I would have liked to keep my field as a date-formatted field _with_ wildcards, but it seems to be impossible. Thanx anyway.

Create an account or sign in to comment

Important Information

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

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.