Vital CRM
Exported data is in text format, how do I convert to date format?

Exported data from the customer, note or consumer are in text format. This date can’t be used for analysis, so how do I convert the date from text format to date format?

Export date format, as the text to be converted to digital date, please refer to the following steps:
1. Enter the formula "= DATEVALUE (F2)", the cell with the "Date of Order" F2, or the date field you want to convert.
2. To convert into a number, click on the cell and select the format on the tab bar, then select date as the number format, and the date of the order will be successfully converted to the date format.

1. Enter the formula "= DATEVALUE (F2)", the cell with the "Date of Order" F2, or the date field you want to convert. 2. To convert into a number, right-click on the cell and select the format on the tab bar, then select date format.
https://faq.vitalyun.com/EN/CRM#3844
How do I transfer customer access permission after the responsible person is not working with company anymore?
Vital CRM版本 4
I deleted an order record after I reviewed the customer’s purchasing record. Why is the customer’s order information completely deleted?
Vital CRM版本 5
How do I add customers?
Vital CRM版本 4
How do I give customer tags?
Vital CRM版本 3
How can I upload and edit customer profile picture?
Vital CRM版本 3
How do I import customer data from an Excel file?
Vital CRM版本 5
How do I import customer data from Google Forms?
Vital CRM版本 3
How do I import customer data from Gmail contacts?
Vital CRM版本 5
How do I import multiple data for a customer?
Vital CRM版本 3
How do I integrate data from other systems through the API?
Vital CRM版本 3