Forum Discussion

MichelleChapman's avatar
MichelleChapman
Qrew Assistant Captain
7 years ago

Formula to Generate Which week of the year it is based on date entered in ""Process Date"" Field.

In search of Formula to Generate Which week of the year it is based on date entered in "Process Date" Field. I tried one and it is telling me how many weeks it has bee since that week instead of the w...
Formulas and functions
Tables and fields
LisaSell1's avatar
LisaSell1
Qrew Trainee
7 years ago
I have a similar form, so I plugged in Mark's variables but made a slight adjustment to 'Week':

var number WeeksSinceFirstWeek = 

(ToDays(LastDayOfWeek([date])-[Ending Saturday of First Week of Year]))/7;

If($WeeksSinceFirstWeek =53,1,

$WeeksSinceFirstWeek+1)

It works when selecting past or future dates (process date), hope this helps