Number of weekdays and weekend days between 2 dates

Hello,

This can be done by creating two virtual or regular numeric fields.

To create the working day field assuming a M-F workweek you can use the custom function created by Brian Element in Feb, 2014. It is on the site but I've attached it again for you. If you've never used a custom function simply copy the file from this post to the Custom Functions.ILB folder of your project. Then in the equation editor you will find it in the custom functions group of the insert function pane. There are instructions of the parameters the function requires. Essentially it's just the start and end date fields.

Your next field weekend days can be created using the @age function and the working days field you just created. The equation would be @age(end_date,start_date)+1 - working_days(or whatever you called your first field) You need to add the +1 because the @age function counts from the end date back to the day before the start date exactly like the VB @datediff function works.

Brian will probably roll his eyes at the second part and wonder why I didn't create a Week_end days custom function. I did take a stab at it before posting this but just couldn't get the syntax correct, hence my work around

Good luck with your analysis.

Hi Steven,
 
Thank you for your answer.
I managed to move the function file above into idea custom function folder however when validating the function it generates the syntax error.
This is how the function line is displayedin in equation editior:
#weekday_dif(START_DATE,END_DATE) 
Both of my fields above seem to be correct from the data type point of view so I am not sure where the problem lies.
 
P.S. As i am relatively new to IDEA scripting where can i see the whole list of functions available that i can use in IDEAScript code module for scripting. I mean functions like: DateDiff or isplit etc. I wasnt able to locate such list anywhere neither in Language browser (BASIC SCRIPT,IDEA SCRIPT) nor in function list in equation editor.
Thank you

Hello,

I can't help you with the P.S. Brian or somebody on the forum that does more scriping that I do should be able to answer that question.

Regarding your syntax problem, one of two things must be happening. Either your start_date or end_date are not in IDEA date format. You can verify this in the equaiton editor by looking at the bottom of the window in the type column for your fields, or the virtual field your creating is not virtual or regular numeric. See screen shot below

If both of the field types are correct, then the only other thing I can think of is your environment variables in Windows are set to French so IDEA is looking for a ; paramater separater not a ,

Hello,

Don't get hung up on the ; parameter separater. I thought perhaps you were in France or using the French version of IDEA. I work in the Canadian government and we use both the English and French versions of IDEA and have computers setup by our IT department in both French and English and we run across this problem often.

I downloaded the custom function to try it myself and ran into trouble. I had to go back to Brian's original post and pull the one he put up a few years ago. I've attached it here. If this doesn't work, you can search for Brian's original post of the function by typing date_dif in the site search bar.

Please try this @Python function after copying the enlosed .py file to the Custom Functions folder of your project and  use it as @Python("Working_Weekend",DATE_COL1,DATE_COL2). It is almost similar to Brian's custom function, but, returns both working days and weekend days. You could get the same output by making a small modification to Brian's custom function.
 
Weekend assumed to be Saturday and Sunday. In Gulf countries, weekend  days are Friday and Saturday.
 
The attachment is actually .py and not .py.txt - please rename it to .py (file upload module is adding .txt by itself)
Regards,
Ravi

Hi Ravi,
Thank you for joining this feed and providing the function.At the moment I dont have ability to utilise Python functions as I dont have Python environment installed on my work machine. However I requested that (IT department needs to approve such request) and hopefully I will be able to see it at work.
I will let you know the outcome once I am able to run it.