Importing created at field

[tayling]

Hi
I am trying to import a date into created at for leads. I have tried several formats including 2023-08-02.
Any suggestions gratefully recieved

Regards

Tony

[shalmaxb]

Perhaps it is because it has to be datetime, format like this: 2022-03-08 15:35:01. I see this format in database and when I export as csv.

[espcrm]

That right. You should do a export and see how it is format and you will be able to see it.

Alternatively you can use Excel or something to add the format with the timer code, for example all to be

15:35:01

If it were excel I would do this:

=CONCAT(A1," ","15:31:01")

[rabii]

Hi
I am trying to import a date into created at for leads. I have tried several formats including 2023-08-02.
Any suggestions gratefully recieved

Regards

Tony

CreatedAt will be override by the system, it a date produced by the system, if you check any core entity at entityDefs you will find that createdAt ("readOnly": true). Only way is to customise this, change the field to be ("readOnly": false) then try import. but i suggest that once you are done with import revert this to it is original behavior to avoid any issues in future.