9 Replies Latest reply on Mar 29, 2014 12:03 PM by Harley Ellenberger

    Combine Date and Time Fields

    Harley Ellenberger

      I have a date field called AirDate.  I have a Date & Time field called AirTime that is custom formatted as 'hh:mm:ss'.  When I make both fields discrete and drag them out to a view it displays like this....


      I want to create a combined Date/Time called "DateTimeCombo"  that will display as m/dd/yyyy hh:mm:ss.  I'd like to be able to do a MAX function on this field so that in the view above MAX([DateTimeCombo]) would give me 3/11/2014 22:54:59


      I can't figure out how to get that combined date/time field.