Month name based on week number

[golfdave]

How can I get Filemaker to return the month name based on week number?

I.E. week # 3 = January, Week Number 6 = February ETC.

I have multiple records that I have grouped based on week number and I would like to show the month Name that those records fall in based on which week number they are in.

Thanks

[doughemi]

You can use Michael Horak's WeekStart custom function (https://www.briandunning.com/cf/1439) in a calculation:

MonthName(WeekStart(weekOfYear; year)).

[golfdave]

How can I get Filemaker to return the month name based on week number?

I.E. week # 3 = January, Week Number 6 = February ETC.

I have multiple records that I have grouped based on week number and I would like to show the month Name that those records fall in based on which week number they are in.

Thanks

 

Thank you Very Much.