I’m having the same issues importing Leads from CSV file in v7.6.4.
I have my date setting as 23/12/2010, also the CSV is in this notation.
During import the day is switched by the month!
If the day is > 12, i.e. 18 then month will 6 and the remaining 12 will add 1 year.
A date like 18/07/2016 will become 07/06/2017 after import!
Looks like a bug to me.
The workflow can correct this date, but I don’t get it to work. I made a new workflow like in the image from DarrenTang, with condition and action for Leads, saved it. But then will this run automaticaly, or do I need to start/enable the workflow somehow?
There is a date format setting while importing, under the button Show File properties. It is not related to the systems date setting.
choose the right date there, to correspond with the date format in the CSV file.
We are curious to see if there has been a solution to this:
ran into the same problem when importing leads from a CSV file
Now quite a number of these have creation dates in the future (2021 and 2022).
The idea to use the WORKFLOW module is nice, if it would work.
Why is the CREATE DATE record not modified through this step?
The LEADS List Views shows all CREATE DATE entries with the same (wrong) values as before …