Newbies Tom11 Posted February 3, 2009 Newbies Share Posted February 3, 2009 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? Link to comment Share on other sites More sharing options...
comment Posted February 3, 2009 Share Posted February 3, 2009 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. Link to comment Share on other sites More sharing options...
Newbies Collins11 Posted February 5, 2009 Newbies Share Posted February 5, 2009 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5553 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now