Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Date formula to show N/A when blank
Summary
How to show a date formula with N/A when BlankContent
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")
0