Skip to main content
Nintex Community Menu Bar
Solved

Calculate days between dates

  • Oct 21, 2021 2:25 AM UTC
  • 1 reply
  • 65 views
  • Translate All

Hi All,

 

I have a question on how to calculate days in Nintex form.

to calculate date that exclude the day-off of the employee. ?

because some of the employee's day off is not Saturday and Sundays. 

 

 

 

 

Best answer by allan

The only possibility is by using the date difference function and calculating the number of saturdays and sundays in between.
You can find which day of the week a date is by storing the value as "Long Date Format" in a text variable.

View original

1 reply

allan
Nintex Partner
Forum|alt.badge.img+9
  • Nintex Partner
  • Answer
  • Oct 26, 2021 3:55 PM UTC

The only possibility is by using the date difference function and calculating the number of saturdays and sundays in between.
You can find which day of the week a date is by storing the value as "Long Date Format" in a text variable.

Translate