The required format for date fields is yyyy-mm-dd. Some of the CSV imports contain date fields, in particular the capture/schedules import. Just don't open the CSV file in Excel and expect the dates to be formatted correctly. Always use the *.xlsx version to make updates, in order to retain required date formatting. The CSV file will have the proper date format. When you're done and ready to import, Save As and select CSV (comma-separated-values) as the file type. Use THE EXCEL-TYPE file to make future changes or updates. Make your changes, format all date columns as shown below, then save the file as an Excel spreadsheet. Summary of this page: Excel will respect your date formatting as long as you save the file as an XLSX (Excel file).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |