Problem: I need a field which holds the month and the year portion of the current date. This field should be auto-filled when an entry is created. Although the field is autofilled, it should be editable by the user later.
Problem detail:
1) A calculated field will no show in the Editform.aspx or in the NewForm.aspx. So it is not editable.
2) Formatting of dates in workflows is not possible with Sharepoint Designer.
Solution:
1) Create a helping field, i.e. month-help, which is a calculated field with your formula, i.e. =TEXT(MONTH(Created),"00")&"."&TEXT(YEAR(Created),"00")
Attention: Formatting to i.e. 08 for August does not work with "MM". It works with "00".
2) Create the "real" field, i.e. month.
3) Create a workflow which starts whenever an item is created and do this action:
Set month to month-help.
Problem detail:
1) A calculated field will no show in the Editform.aspx or in the NewForm.aspx. So it is not editable.
2) Formatting of dates in workflows is not possible with Sharepoint Designer.
Solution:
1) Create a helping field, i.e. month-help, which is a calculated field with your formula, i.e. =TEXT(MONTH(Created),"00")&"."&TEXT(YEAR(Created),"00")
Attention: Formatting to i.e. 08 for August does not work with "MM". It works with "00".
2) Create the "real" field, i.e. month.
3) Create a workflow which starts whenever an item is created and do this action:
Set month to month-help.
Kommentare