You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Calculate Number of Business Days from Today

edited Dec 13, 2022 7:09AM in Taleo Enterprise 4 comments

Summary

Calculate Number of Business Days from Today

Content

I have this formula and results returned "4".    

I am trying to calculate the number of business days between the day the report is run and the CSW Current Status Start Date. 

TIMESTAMPDIFF(sql_TSI_DAY, TIMESTAMPADD(SQL_TSI_DAY, - DAYOFWEEK(MIN("Submission CSW Status - Current"."Current Status Start Date"))+2, MIN("Submission CSW Status - Current"."Current Status Start Date")), NOW())

I appreciate it if you can review the formula and let me know how to correct it?

Sincerely,

Anne Lee

 

 

 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!