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