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
Actually, that didn't work so well - I eventually added another field called Week_numbers:

If([Week number]>52,1,[Week number])

to use in my report & on my form