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
7 years ago
That's what it looks like based on the other formula that doesn't have the right start date...not the new ones you are trying to help me understand...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
The formula above will not give you are correct answer.  My formula will work, but I'm a QSP (Quick Base Solution Provider), so its hard to find the time to walk you though basic Quick Base formulas.  That is why you may need to books some time with me or else take some of the QuickBase University courses about formula building.

If I find the time I can post a single formula to provide you with the Week number but I did the formula in a way that allowed for testing various dates so that is why there are three fields. One for the date to test, on for the first Saturday of the year and one for the Week number.