175
Views
4
Comments
Calculating Number of working days which means excluding the saturday and sunday
Application Type
Reactive

Hey we are working on deal management system where we are keeping a track of deal and revenue generated by our resource for a particular client.So to calculate the number of working days what logic and flow should be used .Please answer

2023-03-16 16-29-51
Paulo Rosário

Hello Astha,

I think this component would be helpful: Working days reactive

It helps manage not only the working days of the week but also holidays etc.

Hope it helps!

Paulo Rosário

2024-06-19 09-49-45
edubaixo

Hi Astha
You can use the built-in function DayOfWeek(dt) 
It returns an integer indicating the week day of 'dt', ranging from 0 (Sunday) to 6 (Saturday).

https://success.outsystems.com/Documentation/11/Reference/OutSystems_Language/Logic/Built-in_Functions/Date_and_Time#DayOfWeek

If(DayOfWeek(YourDate)=0 or DayOfWeek(YourDate())=6,"It's Weekend", "It's Business Day")

Regards
Edu

2025-04-17 05-42-16
Ajit Kurane

Hi Astha,

Please check attached oml file and demo.

You have to put two dates ,

start working date and end working date it will give you total working days excluding weekends.

Ak (personal-xyog61l7.outsystemscloud.com) 

Thanks,


working days.oml
2025-04-17 05-42-16
Ajit Kurane

Hi,

There is client action DiffDaysWithoutWeekends please check logic inside that one,

And make sure function propery should be Yes for the client action 


Hope it heps you.

Thanks,

Ajit Kurane.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.