Hi,

First of all I'm a complete newbie in K2 so please bear with me. I'm creating a leave request form and I would to compute the number of days between the start and end date automatically but holidays and weekends must be disregarded. I've seen a solution about creating a stored procedure but I'm trying to see if this will work. Basically, I created a smartform that list down all the dates which is the key property. I created another property with a value of either 1 for weekdays and 0 for weekends and holidays that is matched against each date. This is how it looks like after populating it.

Let's say I have a range of dates based on the user's input in the start and end date, would it be possible to extract the values under the value property that correspond to this range and add them up?

Any help would be appreciated. Thank you!