CRM On Demand - Administration (MOSC)

MOSC Banner

Subtracting dates giving work days only

edited Jan 29, 2020 4:16AM in CRM On Demand - Administration (MOSC) 4 commentsAnswered

Has anyone encountered the following challenge and came up with a solution?

I need to report the duration of a service request in work days.

For that I need to use a TimestampDiff function to extract the opened time from the closed time giving a number of days.

However, that will give me the total number of days, including weekends.

The challenge is how to come up with a result where the weekends are disregarded.

Example: opened time is on a Friday and closed time is on the following Monday.

The TimestampDiff will result in 3 days but I need the result to be 1 day.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center