Hello!
On a Work Order record, I would like to add a week number based on a date field.
The week number should be calculated based on the 'Production Start Date' field.
So for instance, if the date is 13/04/2022, the week number should be 15.
The value '15' will also be used on a Advanced PDF/HTML document, so it needs to be a stored value field.
Any ideas how to fix this?