If you have a date list column and using SharePoint designer workflow add empty string or empty datestring, you get a date of 1/1/1900. Sometime you want to add blank value to this value and using SharePoint designer workflow. You have no solution either you add extract querystring or use any other designer action. However, there is one easy solution to use:
- Start SharePoint designer and go to the workflow – edit workflow.
- In SharePoint, list settings, change date column to single line of text.
- Update SharePoint designer and add a string variable.
- Now add action update list item and choose value as empty string – workflow variables. Suppose your workflow run on item change or manual.
- Publish your workflow.
- Change column to date again in list settings.
- Now you will get empty date when workflow determine.
SharePoint alert you that you will lost data during changing column from date to text field. But that did not happened to me. You do this operation on your own responsibility.
Add the codes at the top under <xsl:stylesheet
now change the value you want to change:
<xsl:value-of select=”ddwrt:FormatDateTime(@Created, 2057, ‘dd.MM.yyyy hh:mm’)” />
Save the page. Output is:
If you are trying to delete any page or masterpage form the masterpage-galleri and getting this error «This item cannot be deleted because it is still referenced by other pages». Here is the fix. Create a new folder in the masterpage library and using SPD or explorer view drag the file over to this folder. Now delete the folder, so this will also delete the page you are trying to delete.
Make sure you don’t have any site using this pagelayouts or masterpage.
Use these codesnipts to show attachments in dataview:
You can place these wherever you want to show the files.
May be you have tried to create a SQL Database Connection in SharePoint Designer 2010 and receive the message:
Server Error: An error occurred while retrieving the list of databases from (SQL Server): An authentication error occurred. Your logon information may be incorrectly entered, you may not have permission to access this data source, or the requested authentication method may not be supported. Contact the server administrator for more information.
Ok, lets find Administrator. The first thing dropped in my mind is, I am administrator, who i can contact then?
The solution is very easy.
Go to SQL – Right click the SQL-instance – Properties – Security – SQL server and Windows autentication mode – Ok – Right click again SQL instance – Restart – Yes -Yes.
Now lets find the Administrator?