from week to date

[Spencer]

Is it possible when I enter the weeknumber in a field it calculates the first and last day in the week?

Like:

week = 29

Then it will calculate:

first day =13-7-1998

last day =19-7-1998

There is a day to week function in filemaker but not the other way arround.

[BobWeaver]

You can use this formula:

FirstDay = Date(1, 7*(Weekofyear-1)+1, TheYear) - DayofWeek(Date(1, 1, TheYear))+1

LastDay = FirstDay+6

This works because FileMaker lets you enter a day of the month greater than 31 and automatically rolls it over to the appropriate month.