Jump to content
Sign in to follow this  
Tom11

Sort Problem

Recommended Posts

Hello Community at large,

I have a problem that has frustrated me for days now.

Chief Complaint: I can not figure out how to sort by day of the month only (within dates covering only one month)

Details: We have a Demographics type data base and I need to be able to make lists of everyone with dates in the upcoming month (there are actually four date fields I have to search through).

I currently run a search like 2/{1..31}/* to find all dates that fall within the month, and then view them all in a layout I created for this purpose. But the results need to then be organized by the day of the month. The problem I have run into so far is that FMP seems to follow the logical globally accepted rule that the year is actually important to chronology. I know it can be done, but how?

Share this post


Link to post
Share on other sites

Same month, but not the same year? You will need to add a calculation field (result is Number) =

Day ( YourDateField )

and use it for sorting.

Share this post


Link to post
Share on other sites

You are a great person, thank you!

I am new to fmp so I am figuring this out as I go. That looks simple enough that I should of known how to do it, but I would of torn my hair out trying to solve it on my own.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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