importing date time field from csv

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • livewire
    Senior Member
    • Nov 2016
    • 102

    #1

    importing date time field from csv

    I have some leads which includes a date time field. So i created a date time field and changed the date and time format in my CRM. But when i try to import it gives a validation error
    Invalid date-time value
    .

    In my csv the date and time is saved as ex:
    4/26/2025 12:07
    What would be the correct way to import this? i cant add it as a text field coz i wont be able to sort it by the date/time on my lead list

    Im using espocrm 9.1

    thanks


  • lazovic
    Super Moderator
    • Jan 2022
    • 955

    #2
    Hi livewire,

    Please try to use the following settings in Step 1 of the import process:

    Click image for larger version

Name:	image.png
Views:	0
Size:	8.4 KB
ID:	117355
    Last edited by lazovic; Today, 02:18 PM.

    Comment

    Working...