AnsweredAssumed Answered

What week am I in??

Question asked by FrankFarmer on Mar 25, 2011
Latest reply on Mar 27, 2011 by FrankFarmer

Title

What week am I in??

Post

Hi,

I am new to FileMaker . I have searched and I cant find a solution to my problem.

I am trying to find what week we are in in relatation to known dates.

Fields I have.

DATE START - user enters date

DATE FINISH = START DATE + 56

DAYS TILL FINISH = DATE FINISH - Get ( CurrentDate )

IN WEEK = ??????

What I am looing for is that during week one (day 1 - 7) the result for IN WEEK will be 1. Week two or days 8-14 the result will be 2. Days 49 - 56 Week 8 etc...

Help Please...

Thanks

Frank

Outcomes