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

Case statement with Date timestamp field looking for NULL value

Accepted answer
57
Views
11
Comments
edited Mar 30, 2016 7:20PM in Reporting and Analytics Taleo Enterprise 11 comments

Content

I have written a formula to check for the2nd  interview date field and if it’s empty then assign ‘not filled out’ else enter that date. The formula syntax doesn’t give any errors but the report is not refreshing and showing any data.

Here is the formula I have written that saves without errors

CASE WHEN (CAST ("Submission Dates"."2nd Interviewed Date" AS DATE)) IS NULL THEN (CAST( 'Not filled out' AS DATE)) ELSE CAST ( "Submission Dates"."2nd Interviewed Date" AS DATE) END

Please point out what looks incorrect that might be causing my report to error out.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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