I need to set up a month field that grabs the month from an existing date field automatically. Can someone tell me how to do this? Seems like it should be simple and straightforward.
I have an auto-enter (under field Options) that will set the Year & Month (yyyy_mm). I include the year so that multi-year reports can be sorted (and graphed) chronologically.
However, if you only need to DISPLAY the month for any date (in reports), you can simply place the date field on the layout and format (in Inspector) to show only the month (mm or JAN or January, for example):
I am going to move this thread from the FileMaker Community Feedback Space, which is specifically for input on the Community itself, to the Discussions Space where you should receive more views and potentially more feedback on this topic!
Retrieving data ...