Follow the format as defined in your master form Example: Master form format: YY/MM/DD Date to import: December 31, 2014 Spreadsheet data: 141231
Dates with leading zeros If the data is shorter than the expected number of digits, it will be padded with preceding 00s. Example: YY/MM/DD format 123 in the spreadsheet would be filled as 00/01/23 (January 1, 2000).
Date fields left blank The default defined in the master form will be used.