5 Replies Latest reply: Oct 11, 2016 4:47 AM by Nayan Lalla RSS

    Different Date Formats

    Nayan Lalla

      Hi

       

      I have a QV Model that is extracting data from various excel spreadsheets.  I have a field called "Claim Date" , where the date format is is not consistent in these excel spreadsheets.  How do i create a formula in a list box to show a consistent date format as'DD-MMM-YY". (see below).

       

      Kind regards

      Nayan

       

       

        

      Claim DateIdeal Claim Date Format
      2013-07-1717-Jul-13
      2013-07-1616-Jul-13
      2013-07-0909-Jul-13
      2013-07-0707-Jul-13
      2013-07-0606-Jul-13
      42649.2136906-Oct-16
      42644.1238401-Oct-16
      42644.1238301-Oct-16
      42642.4055429-Sep-16
      42642.4054429-Sep-16
      42641.2742728-Sep-16
      42641.2742128-Sep-16
      42640.2169427-Sep-16
      4263320-Sep-16
      4263219-Sep-16
      4263118-Sep-16
      4263017-Sep-16
      4262916-Sep-16
      4220520-Jul-15
      4215228-May-15
      4213713-May-15
      4212430-Apr-15
      4211420-Apr-15