Last updated on JULY 12, 2016
Applies to:Primavera Contract Management - Version 10.0 to 13.0 [Release 10.0 to 13]
What values can be imported into Contract Management? For importing to succeed the date format should be yyyy-mm-dd.
To change the date format:
1. Highlight the entire all date columns, go to Format > Cells.
2. On the number tab, select custom and enter the format yyyy-mm-dd.
3. Save the file and it should import successfully.
NOTE: If the file was saved as an Excel spreadsheet, the formatting will still be there when the file is opened again. If the files was saved as a .csv file, formatting will need to reapplyed every time it is opened in Excel, or it'll have to be edited it in Notepad. Import date format. How to import an excel document. Import does not work.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms