Announcement

Collapse
No announcement yet.

Importing created at field

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Importing created at field

    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

  • #2
    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.

    Comment


    • esforim
      esforim commented
      Editing a comment
      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")

  • #3
    Originally posted by tayling View Post
    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.
    Rabii
    Web Dev

    Comment

    Working...
    X