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
MichelleChapman's avatar
MichelleChapman
Qrew Assistant Captain
6 years ago
Maybe I should create a [Report Date] formula-date field.  LastDayofWeek([Process Date)] 
Then change the [Ending Saturday of First Week of Year] formula to LastDayofWeek(FirstDayofYear([Report Date]))

Think that might work or add another field and still get the same result?