
Is there a button to activate the week numbers?
Adriaan
2 Antworten
For Standard Objects:
1.Click Setup | Customize | choose the object where we would like to create the field with.
2.Select Fields | Click the New Button to create a new field
3.Select the option Formula
4.Fill in the field Name and select the Number option
5.On the next page simply use this syntax format:
MOD(FLOOR( (DATEVALUE(CreatedDate) - DATEVALUE("2019-01-01" ))/7),52)+1
For Custom Objects:
1.Click Setup | Create | Object | choose the object where we would like to create the field with.
2.Click New Button on the section where we can create a New field
3.Select the option Formula
4.Fill in the field Name and select the Number option
5.On the next page simply use this syntax format:
MOD(FLOOR( (DATEVALUE(CreatedDate) - DATEVALUE("2019-01-01" ))/7),52)+1