This content has been marked as final. Show 5 replies
I would like to know how to create a new column called "ClosedStatusDate" in the table below and then the data in this column should be the max date out of the 3 columns called "Date Finalised", "Date Closed" and "Date Converted" (Whichever has the last date). If there is no date then "ClosedStatusDate" will be blank.
Please help? Should be fairly easy but I'm a beginner. Thank you
The table looks like this:
|Case ID||Date Reported||Date Finalised||Date Closed||Date Converted|