5 Replies Latest reply: Feb 4, 2014 5:11 AM by Joyce Charles RSS

    How do I create another column in the same table that takes the max date from 3 other date columns

      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 IDDate ReportedDate FinalisedDate ClosedDate Converted
      1234529/10/200931/11/201302/02/2011
      1234623/05/201204/02/2014
      1234701/03/201314/06/2013
      1234822/01/201424/01/2014
      1234931/01/2014