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

OBTI Analysis Comparing Dates

edited Jul 12, 2018 10:54AM in Reporting and Analytics for HCM 19 comments

Summary

I am not able to compare dates in analysis

Content

"Hi, I am trying to perform a query which i think should be easy but i'm suffering from just looking at it for too long!

I am trying to perform a query to retrieve the record by comparing  two date columns values from the different subject of areas :

1."Workforce Management - Worker Assignment Event Real Time"."Assignment Event Details"."Effective End Date"

2.TIMESTAMPADD(SQL_TSI_DAY,-1,"Workforce Management - Worker Assignment Real Time"."Worker Assignment Details"."Effective Start Date")

and  My query has to compare the values of 1) and 2) above.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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