1904 issue when data is extracted from the SharePoint list.

We have an option in SharePoint to export the SharePoint list to an excel.

When a user extracts a report and enable the "user 1904 date system" under Excel Options-> Advanced->When calculating this workbook, the data columns in the excel would get added by 4 years and 1 day.

For example: If the date column has the value 08/03/2019, it would get converted to 09/03/2023.

Please click here to know more about the excel date systems.

Please follow the steps to correct the shifted dates!

Correcting Shifted Dates

If you link from or copy dates between workbooks, or if you change the date system for a workbook that already contains dates, the dates may be shifted by four years and one day. You can correct shifted dates by following these steps:

1. In an empty cell, enter the value 1462.

2. Select the cell. On the Edit menu, click Copy.

Note In Excel 2007, select the cell, and then click Copy in the Clipboard group on the Home tab.

3. Select the cells that contain the shifted dates. On the Edit menu, click Paste Special.

Note In Excel 2007, select the cells that contain the shifted dates, click Paste in the Clipboard group on the Home tab, and then click Paste Special.

4. In the Paste Special dialog box, click to select the Values check box under Paste, and then click to select either of the following check boxes under Operation. |Select this| If| |---|---| |Add| The dates must be shifted up by four years and one day.| |Subtract |The dates must be shifted down by four years and one day.|

5. Click OK.

Repeat these steps until all the shifted dates have been corrected.

Comments

This site has exceeded its maximum storage limit.Error while uploading file to document library - SharePoint

Issue: Unable to upload files to SharePoint document library irrespective of the document size. Solution: When you delete items from a SharePoint site, they're sent to the site Recycle Bin. When you delete items from a site Recycle Bin, they're sent to the site collection Recycle Bin. A SharePoint site collection administrator can view and restore deleted items from the site collection Recycle Bin to their original locations. If an item is deleted from the site collection Recycle Bin, or it exceeds the retention time, it is permanently deleted. 1. Click the gear icon and go to the "Site Settings" page. 2. Under the Site Collection Administration, click on "Recycle bin". 3. Delete the unwanted files.

How to Migrate a InfoPath List Form to another List Form in SharePoint 2013

I encountered an issue recently where the Info Path form got published accidentally with improper layout. As we all know that Info Path does not maintain versions and it is impossible to revert to the previous versions. Luckily I had the back up of the SharePoint list template from where I could open the previous version of the Info path form. Following are the steps I tried to migrate the Info Path form from the back up to the new SharePoint list. 1. Create a new SharePoint list from the list template. 2. Open the newly created list and click on "Customize form" to open the form in Info path designer. 3. Extract the source files by clicking on File->Publish-> Export Source Files. 4. Update the manifest file with the URL, List ID, Content Type ID of the list to which the Info path form has to be published. Steps to update the manifest file: 1. Get the List ID from the URL by clicking on List settings. The List Id would be something like List=%7B691FF1A0%2...

Service Unavailable Error while accessing SharePoint Central Admin

Central Administration in SharePoint Server is where you go to perform administration tasks from a central location. Sometime we encounter the "Service Unavailable" error message while trying to access the central admin. Please follow the steps below to resolve the issue. 1. Open the IIS. 2. Expand the server name. 3. Click on Application Pools. 4. Please check whether the Central Admin application pool is started. If not, please start. 5. Also check whether the Central Admin site is started by expanding the "Sites". Sometimes the issue persists even after starting the application pool and the site. In that case, please go to the application pool. Click on advanced settings-> Identity->Please enter the credentials in the App Pool Identity and save.

All About SharePoint and Other Technologies

Search This Blog