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.

Count of people with the same birthday

jess
in Layouts

Featured Replies

I've got a date field...with values such as

9/1/1934

12/11/1966

How would I count the number of people that have the same birthday, by date...meaning create a report that provides an export like this:

9/1 312

9/2 278

9/3 289

I know how to do sub-summary reports...but its finding and sorting thats giving me fits. Do I have to break up the date of birth field first to narrow down my set? Ultimately I will have to do an export of all these people who's birthday land on the same day and do a mail merge.

I'm using FM8

Thx...

Edited by Guest

You need a break field that will have a common value for "all these people who's birthday land on the same day".

Try a calculation field (result is Date) =

Date ( Month ( BirthDate ) ; Day ( BirthDate ) ; 4 )

Sort and summarize by this field. In Layout mode, format the field to display Month/Day only.

Create an account or sign in to comment

https://fmforums.com/topic/45487-count-of-people-with-the-same-birthday/
Go to topic listing

Important Information

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

I accept

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.