Hi John,

What do you want the output of this to be and how will you use it? If you still need help, let me know and we can take this off line and I'll be happy to help.

Bruce

John Wenmeekers wrote:
Hi Bruce,

thanks for your reply.

Basically I have to start with the two values I have: weeknumber and year.

My formula to have the Saturday is:
(weekNumber -1) * 7 + Date(1;1; yearNumber) + (7- DayofWeek(Date(1; 1; yearNumber)))

I guess I can change that to have the Friday.

My biggest concern is if FileMaker will accept the same day as beginning and ending of a week.

Well....I will try and see where I end.

Thanks

JW

Reply via email to