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

OTBI date check End-of-time

edited Sep 22, 2020 8:55AM in Reporting and Analytics for HCM 3 comments

Summary

OTBI date check End-of-time

Content

Hi, 

I am wondering if anyone has tried to check for end of time on a date column in OTBI.

I wrote this. But it doesn't work. Any ideas?

 

CASE WHEN "Worker Assignment Details"."Effective End Date" = CAST('31/12/4712' AS DATE) THEN NULL

ELSE
"Worker Assignment Details"."Effective End Date"
END

 

 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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