Formatting Dates for Importing into Zendesk Sell
How should I format dates before importing into Zendesk Sell?
To ensure your reports are accurate, it's crucial to format dates correctly before importing them into Zendesk Sell. The recommended format for importing is YYYY-MM-DD. However, the importer also accepts DD/MM/YYYY and MM/DD/YYYY formats, provided they match the account format in your Timezone settings.
If you encounter issues with date formats after importing, you can export a smart list of records and use the bulk importer to correct them. Remember to avoid using two-digit years and formats like yyyy/mm/dd or yyyy-dd-mm. For more details, check out the article onCreating a CSV file to import leads, contacts, or deals.
More related questions
What date formats are accepted when importing data into Zendesk Sell?
Zendesk Sell accepts several date formats when importing data, but it's important to match the format with your account's Timezone settings. The recommended format is YYYY-MM-DD. You can also use DD/MM/YYYY or MM/DD/YYYY, but ensure consistency…
How can I manually update date fields in Zendesk Sell?
Manually updating date fields in Zendesk Sell is straightforward. You can either follow the prompted date format in the field or select a date from the calendar. The format will be either MM/DD/YYYY or DD/MM/YYYY, depending on your Timezone…
What should I do if my imported dates are incorrect in Zendesk Sell?
If your imported dates are incorrect in Zendesk Sell, you can correct them by exporting a smart list of the affected records and using the bulk importer to update them. Ensure that the date format in your file matches the account format in your…
Why is it important to use four-digit years in Zendesk Sell date fields?
Using four-digit years in Zendesk Sell date fields is crucial to avoid import errors and ensure data accuracy. Two-digit years can lead to misinterpretation and incorrect data entries. Always use formats like YYYY-MM-DD, DD/MM/YYYY, or MM/DD/YYYY,…
Interested indeflectingover 70% of your Zendesk support tickets?
Zendesk Support Tickets
Zendesk Messaging (live chat)
Join1,000+ companies reducing their support costs and freeing up support agents for more important work
“We needed an AI agent integrated within our current tools. My AskAI was the only solution that wasn't going to disrupt our operations.”
Zeffy
“At the end of last year I was given the challenge - how can we provide the same or better service, without hiring anyone?”
Zinc
“My AskAI blew everybody else out of the water. It made the selection process very easy for us.”
Customer.io($50M+ ARR)
“It now resolves 71% of queries (over 35,000 every month), meaning more time solving complex issues and improving UX.”
Freecash
“We needed an AI agent integrated within our current tools. My AskAI was the only solution that wasn't going to disrupt our operations.”
Zeffy
“At the end of last year I was given the challenge - how can we provide the same or better service, without hiring anyone?”
Zinc
“My AskAI blew everybody else out of the water. It made the selection process very easy for us.”
Customer.io($50M+ ARR)
“It now resolves 71% of queries (over 35,000 every month), meaning more time solving complex issues and improving UX.”
Freecash
Reduce support costs.Spend more time on customer success.
