Need help on Dates issue
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.