Oracle® Social CRM Applications Administration Guide > Administering Oracle Sales Prospector > Importing Data Files into Oracle Sales Prospector >

Changing the Date Format on Your Computer


To avoid errors related to invalid date formats, you can change the default date format for the program that you use to open or edit your CSV file, (for example, Microsoft Notepad), to be the required format: YYYY-MM-DD. Alternatively, you can change the default date format on your computer to the required YYYY-MM-DD date format by completing the following procedure.

NOTE:  We recommend that you use Notepad instead of Excel so that data renders correctly during importing.

To change the date format on your computer

  1. On your Microsoft Windows computer, launch the Control Panel.
  2. Depending on your computer setup, either:
    • Click Date, Time, Language, and Regional Options, and then click Change the format of numbers, dates, and times.
    • Click Regional and Language Options
  3. Under the Regional Options tab, click Customize.
  4. Click the Date tab.
  5. Select yyyy-MM-dd as the default Short date format.
  6. Select - as the Date separator.
  7. Click OK.
Oracle® Social CRM Applications Administration Guide Copyright © 2009, Oracle. All rights reserved.