Direkt zum Hauptbereich

Sharepoint: Field with month portion of the current date

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.

Kommentare

Beliebte Posts aus diesem Blog

Error: HPDMG0764E An internal error has occurred. (status 0x14c012fc)

Error: HPDMG0764E An internal error has occurred. (status 0x14c012fc) pdadmin sec_master> user create dg1234 uid=dg1234,cn=team1,cn=users,o=company lala lala ********** Could not perform the administration request Error: HPDMG0764E An internal error has occurred. (status 0x14c012fc) Description: After the upgrade from Policy Director (policy server) V5.1 to V6.0 the errors above occured when trying to write to the registry. Solution: The task of updating the ldap schema did not work well for some reason. After doing it again the errors did not occur again: # ivrgy_tool -d -h ldap_host -p port -D ldap_admin -w pwd schema

WebSphere Application Server LDAP: The administrative user ID does not exist in the user repository.

When you try to enable global security with ldap authentication you get the following error when configuring your ldap repository (IBM Directory Server): The administrative user ID does not exist in the user repository. Reason: The bind user must be searchable. This means that an ldapsearch with this user as bind user must return his own entry. If this does not work, you have to add an aclEntry: vi change-was7101-aclentry.ldif dn: uid=was7101,cn=mygroup,cn=admusr,o=mycomp aclentry: access-id:UID=WAS7101,CN=MYGROUP,CN=ADMUSR,O=MYCOMP:normal:rsc $ ldapmodify -h myhost -x -D "cn=root" -w ******* -f change-was7101-aclentry.ldif modifying entry "uid=was7101,cn=mygroup,cn=admusr,o=mycomp" Now user was7101 can do an ldapsearch to find itself and therefore you can use it to configure you LDAP repository. This article gave me the hint: http://www-01.ibm.com/support/docview.wss?rs=767&uid=swg21219253