12 Replies Latest reply on Jan 21, 2014 8:58 AM by Phillip Burger

    Schema.ini file -Date field not recongnized

    Siddharth Surana

      Hey Guys  I have a problem with the schema file that I am making. It fails to identify the date fields in my file.   The different Date Time Format declarations I have used are : "yyyy-mm-dd", yyyy-mm-dd, "yyyy-mm-dd hh:mm:ss" and yyyy-mm-dd hh:mm:ss. None of these seem to work with the file as the Jet engine fails to recognize it as a date filed. Any thoughts would be appreciated.  The Date time in my data is in this format - 2013-05-20 22:00:00   schema file screen shot.png