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

OBI Filter Week To Date

Received Response
77
Views
2
Comments
edited Nov 7, 2014 2:08PM in Reporting and Analytics Taleo Enterprise 2 comments

Content

Hello OBI Users,

I was asked recently how to create a filter that would give results based on the week to date and I want to share my solution with you.

Assuming your week starts on a Monday I created an object with the following formula:

TIMESTAMPDIFF(sql_TSI_DAY, TIMESTAMPADD(SQL_TSI_DAY, - DAYOFWEEK(MIN("Requisition Dates"."Req. Creation Date")) + 2 , MIN("Requisition Dates"."Req. Creation Date")), NOW())

Here is the calculation for the start of the week.  If your work week doesn't start on monday the +2 can be modified to move the start date: +3 would be Tuesday, + 3 would be Wednesday, etc.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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