9 Replies Latest reply: May 16, 2018 2:12 PM by Vishwarath Nagaraju RSS

    Formating Date in Load statement from excel file.

    Erika Leal

      Good day!

       

      I have an excel file with several Date fields that QV can not recognize as a date and I can't figure out why.  I have tried the following on the load script:

       

      Date([Field Name],'MM/DD/YYYY') as DateCreated,

      (the result is it doesn't load any values for the field at all)

       

      I have also tried using the 'Number' tab in the 'Properties' box after import.

      (The result of this is it doesn't visually change the format of the date field at all).

       

      Any input or advise is greatly appreciated.  I am attaching a sample from the excel file I am trying to load.