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

    Two different date formats in one excel file

    Max Maudin

      Hi,

       

      I have an Excel file with 2 differet date formats:

       

      Example:

       

      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?