Help

Workday_diff with linked holidays gives error

Topic Labels: Formulas
Solved
Jump to Solution
963 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Blinkt_Uit
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi there,

I have a question for our PTO system. I like to calculate the workdays between the PTO startdate and enddate minus the holidays + non working days (for partime employees). I want to do this in a linked field because of large number of dates. But I constantly get an error when implementing.
image

  1. I’ve made a table for all days in the coming year
    image

  2. I’ve made a lookup field referencing to this table.
    image

  3. Then a field with a formula field

WORKDAY_DIFF({startPTO}, {endPTO}, {Days in year})

I’ve also tried this advice from Justin_Barret in this topic. But unfortunately it keeps showing an error.

WORKDAY_DIFF({Start Date Field}, {End Date Field}, {Lookup Field} & "")

Does anybody have an idea? Or can point me in the right direction :grinning_face_with_big_eyes:

Many Thanks

1 Solution

Accepted Solutions
Blinkt_Uit
5 - Automation Enthusiast
5 - Automation Enthusiast

I found it! Date settings were not set to ISO. Bummer.

See Solution in Thread

2 Replies 2
Blinkt_Uit
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi all, I was thinking it could also be that it needs to be built in a completely different way. If you have any tips for that, I’d love to hear them too. Thanks in advance.

Blinkt_Uit
5 - Automation Enthusiast
5 - Automation Enthusiast

I found it! Date settings were not set to ISO. Bummer.