General Discussions

Discuss any topics that are not product-specific here.

Business Days Formula- Question

Henrytabares
7 - Meteor

Dear Community, 

 

I was using this formula without issues: BUSINESSDAYS([Date Requested], [Date Closed])

Now I am facing an error (argumnents must be strings...but I am comparing dates). 

I've found tons of discussions and even a Challenge (Nª252), but the solutions there provided are quite more complicated...to calculate just network days...

Do you know if something has changed with the Business days formula?

Thanks for your support, I've been struggling with this hours. 

Henry

2 REPLIES 2
binuacs
20 - Arcturus

@Henrytabares The businessdays function is working for the date type fields

binuacs_0-1646315882708.png

 

Henrytabares
7 - Meteor

Thank @binuacs for your fast response. 

 

Let me give you more context:

 

I am comparing to date columns (i.e.)

 

Column A: 2021-11-26

Column B: 2022-01-03

 

Data type of both columns "Date"

 

If I use this formula: BUSINESSDAYS([Column A],[Column B]) It triggers following error: "Parse error at char(0):Argument 1 of date time diff is not a string". 

 

Hope this give you more context. 


Tks!

 

Henry

 

 

 

Labels