Hi,
I have about a years worth of leads I'm importing from excel into Zoho. In Excel I have a column for MM/DD/YYYY
of when that lead came to me. But when I import into Zoho, they all over October 10th, 2022. That's kind of worthless to me, because I want to see the actual dates.
I created a new column called Date Added and added the dates that way, but now my new leads coming into Zoho all have a created time that is accurate.. But my old leads all have a created time that is October 10th, 2022. And the column I Have for "Date Added" that has the real dates of the "Created Time" is its own column so sorting on that doesn't work since the new leads don't get new "Dates Added" in there because it goes under "Created Time".
Is there anyway for me to just update the dates in the "Created Time" for my leads I imported?