Sharepoint Calculated Date column
Question
Answers
-
Hi,
To exclude the weekends and do the subtractions, you can try to use the YEAR, MONTH, DAY and WEEKDAY function to handle the date in use and use IF function to perform the subtractions accordingly.
Another workaround is that we can create an Event Receiver for this, with SharePoint Object Model and other powerful APIs, we can update the Board Date column with the calculated value when there is a new item added to this list.
SharePoint Object Model - SPListItem class
Add, Update and Delete List Items Programmatically in Sharepoint
More information about SharePoint Object Model:
http://msdn.microsoft.com/en-us/library/ms473633.ASPX
Here is a step by step sample on creating a simple Item added event receiver for Custom List in SharePoint 2010:
http://msdn.microsoft.com/en-us/library/ff398052.aspx
More information on Event Receiver for your reference:
http://msdn.microsoft.com/en-us/library/gg749858(v=office.14).aspx
http://msdn.microsoft.com/en-us/library/ff408183(v=office.14).aspx
Two links about DateTime Structure
http://msdn.microsoft.com/en-us/library/system.datetime(v=vs.110).aspx
A demo about Programming DateTime using C#
http://www.c-sharpcorner.com/uploadfile/mahesh/working-with-datetime-using-C-Sharp/
Best regards
Patrick Liang
TechNet Community Support
- Marked as answer by Dennis Guo Sunday, February 23, 2014 1:54 PM
All replies
-
Hi,
To exclude the weekends and do the subtractions, you can try to use the YEAR, MONTH, DAY and WEEKDAY function to handle the date in use and use IF function to perform the subtractions accordingly.
Another workaround is that we can create an Event Receiver for this, with SharePoint Object Model and other powerful APIs, we can update the Board Date column with the calculated value when there is a new item added to this list.
SharePoint Object Model - SPListItem class
Add, Update and Delete List Items Programmatically in Sharepoint
More information about SharePoint Object Model:
http://msdn.microsoft.com/en-us/library/ms473633.ASPX
Here is a step by step sample on creating a simple Item added event receiver for Custom List in SharePoint 2010:
http://msdn.microsoft.com/en-us/library/ff398052.aspx
More information on Event Receiver for your reference:
http://msdn.microsoft.com/en-us/library/gg749858(v=office.14).aspx
http://msdn.microsoft.com/en-us/library/ff408183(v=office.14).aspx
Two links about DateTime Structure
http://msdn.microsoft.com/en-us/library/system.datetime(v=vs.110).aspx
A demo about Programming DateTime using C#
http://www.c-sharpcorner.com/uploadfile/mahesh/working-with-datetime-using-C-Sharp/
Best regards
Patrick Liang
TechNet Community Support- Marked as answer by Dennis Guo Sunday, February 23, 2014 1:54 PM
