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
RyanStanford1's avatar
RyanStanford1
Qrew Captain
7 years ago
This may work for you, If you have a field which will have the start of the year, say "Year Start" then you can calculate how many days between Year Start and Process Date, divide by 7, to get the week.


Int(ToDays([Process Date] - [Year Start])/7 +1)