Question
How should I format the dates in my file before I import the data into my account? How should I format the year in a date field?
Answer
Date fields can be updatedmanuallyand through theimporter. The import format of these fields is very important in order for your reports to be correct. Once the dates are successfully imported into your account, you canadjust the format的日期displayed.
Update date fields manually
When manuallyeditingthe date field on a record, follow the prompted date format in the field or select a date from the calendar. The date format will either be MM/DD/YYYY or DD/MM/YYYY depending on the时区selected in账户settings.
For more information, seeChanging your Sell account timezone and date format.
Update date fields by importing
If you areimporting datainto a date field, the recommended format is YYYY-MM-DD. The importer will also accept dates in the format DD/MM/YYYY and MM/DD/YYYY, but you must make sure the date format in your filematches the account format selectedin your时区settings.
If you imported a file and the dates were formatted incorrectly, you can always correct the data in the date field.Export a smart listof the records with the date field that needs updating anduse the bulk importerto make a change to many items at once.
For more information on preparing your import file with the appropriate date formats, see the article:Creating a CSV file to import leads, contacts, or deals.
0 Comments
Pleasesign into leave a comment.