What week am I in??
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...