Skip to main content
Solved

WORKDAY_DIFF returning Error

  • May 4, 2023
  • 2 replies
  • 87 views
M
Forum|alt.badge.img+1

Hello all, I am trying to use the WORKDAY_DIFF Formula but it is returning #ERROR and I am struggling to determine why.  The IF,AND piece is working, the WORKDAY_DIFF is not (on its own or with the rest of the formula). 

IF(
  AND({DateSubmitted}, {DateCompleted}),
    WORKDAY_DIFF({DateSubmitted},{DateCompleted})
)

My fields are set to ISO dates. DateSubmitted is the Created Time auto value, and the DateCompleted is a formula - 
IF(Status="Done",NOW())

Any help you can provide would be much appreciated. Thank you! 

Best answer by Brian_Swanson

Good Afternoon @MegFox! 

This would likely be an issue with time zone.  In the Date Submitted Field and Date Completed Field check to make sure that you are using the same time zone.  

2 replies

B
Forum|alt.badge.img+7
  • Brian_Swanson
  • Participating Frequently
  • Answer
  • May 4, 2023

Good Afternoon @MegFox! 

This would likely be an issue with time zone.  In the Date Submitted Field and Date Completed Field check to make sure that you are using the same time zone.  

M
Forum|alt.badge.img+1
  • MegFox
  • Author
  • New Participant
  • May 4, 2023

Good Afternoon @MegFox! 

This would likely be an issue with time zone.  In the Date Submitted Field and Date Completed Field check to make sure that you are using the same time zone.  


Yes! That did the trick, thank you so much! 

Terms & ConditionsAccessibility statement