7 Replies Latest reply: Feb 7, 2018 5:28 AM by Max Maudin RSS

    Two different date formats in one excel file

    Max Maudin



      I have an Excel file with 2 differet date formats:




      Number              Dateformat

      5                        01.01.2017

      2                        01-JAN-2017


      I tried in the script the function

      Date(Date#(Dateformat, 'DD-MMM-YYYY'), 'DD.MM.YYYY')


      Then it changes the date from number 2 in the correct date (01.01.2017). But the date of number 5 now disappears in the app-->Only the date of number 2 appears in the correct date Format (DD.MM.YYYY), but not the date of number 5. How can i set the function that both Dates are in the app?