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

Date formula to show N/A when blank

Received Response
24
Views
4
Comments
edited Jun 6, 2019 2:02PM in Reporting and Analytics Taleo Enterprise 4 comments

Summary

How to show a date formula with N/A when Blank

Content

I am using the following formula and would like to use N/A in the column when no date associated.  Also the date in the database shows as year, month and day how can that be changed in the formula.  We want the time stamp so need to be able to update to show dd/mm/yyyy

EVALUATE_AGGR('MAX(CASE WHEN %1 = %2 and %3 = %4 THEN %5 END)' AS CHARACTER(200),"Submission CSW Status - Historical"."Historical Step Name",'NEW',"Submission CSW Status - Historical"."Historical Status Name", 'Initial Review Complete' , "Submission CSW Status - Historical"."Submission Historical Status Start Date")

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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