Title
Need help on Dates issue
Post
I have Filemaker Pro 12 for MAC. Currently, in the database I am working on, there is a field for range of dates for when students go to camp. It has a beginning and ending within the same field. I will want to make into two different fields Beginning Date and Ending date. When I have a student whose birthdate happens to fall within the time they are at camp, I want an X placed in the Birthday field so that our counselors know to have a celebration for that student.
Do you agree that the Week field must be split into two separate fields? And if so, how to write it to put X in Birthday field.
Thank you in advance.
Yes it should be two fields of type date. There should also be a date field or a calculation that returns a date for the camper's birthday.
Your calculation for Birthday might be:
If ( StartDate < Birthday and EndDate > Birthday ; "x" )