Category Archives: Uncategorized

Calculating Working Hours – hours in last day

…this post was published on 2016 March 31. The final step is to calculate working hours in the last day. The procedure is similar with working hours in first day​​ We need first, 2 new columns, calculated columns, which will calculate for … Continue reading

Posted in CalculatedColumn, Sharepoint Online, Uncategorized | Comments Off on Calculating Working Hours – hours in last day

Calculating Working Hours – hours in first day

…this post was published on 2016 March 31. The last 2 steps are those for calculating hours in first  and last day. Let’s begin with the first day. As I said in main post, we assume that the working day begins at 8.30am … Continue reading

Posted in CalculatedColumn, Sharepoint Online, Uncategorized | Comments Off on Calculating Working Hours – hours in first day

Calculating Working Hours – days in full weeks

…this post was published on 2016 March 31. Well, this is the hardest step in this scenario because we need to analyze the interval between StartDate and EndDate, to get the number of full weeks. The structure could looks like below: To … Continue reading

Posted in CalculatedColumn, Sharepoint Online, Uncategorized | Comments Off on Calculating Working Hours – days in full weeks

Calculating Working Hours – days in last week

…this post was published on 2016 March 31. Let’s assume that EndDate is Thursday as bellow To calculate full working days in last week, I’ve created a calculated column , numeric type with 0 decimals. I named it: ​DAYS_LAST_WEEK ( Full working days in … Continue reading

Posted in Uncategorized | Comments Off on Calculating Working Hours – days in last week

Validation: Force only Sundays

…this post was published on 2016 February 02. How can force Sharepoint to permit only past sundays in a date column? The request was posted at this address​. To permit only sundays, it’s quite easy. You configure a validation condition at column … Continue reading

Posted in CalculatedColumn, Uncategorized, Validation | Comments Off on Validation: Force only Sundays

Powershell and Sharepoint library

…this post was published on 2012 October 20. as usual, starting from a question, let’s work togeter and see what Powershell can do to help us. First think to do, open Sharepoint 2010 Management Shell Console, using an admin account. Next … Continue reading

Posted in Powershell, Sharepoint, Uncategorized | Comments Off on Powershell and Sharepoint library

Filter Data View via Drop Down Menu

…this post was published on 2011 June 22. The example started from a post on Sharepoint Forum.​ So, first task it’s to create an .aspx file, in which I attached a list data view. This zone can be a data web view … Continue reading

Posted in Uncategorized | Comments Off on Filter Data View via Drop Down Menu