Forum

[SOLVED] Error mess...
 
Notifications
Retirer tout

[SOLVED] Error message "the field xxx should be a valid date" when importing csv File

3 Posts
2 Utilisateurs
0 Reactions
3,856 Vu
(@tjaeckle)
Posts: 15
Active Member
Début du sujet
 
[#3150]

Hello!

I have exported from one Projeqtor instance some activities as CSV and want to import them now to another instance (version 5.2.4). For several fields (creation date, validated start date, ..) I get the above error message.
In the CSV file this dates are in the format
...;15.01.2016;...
When I imported some projects in the same way (and with an identical format) I have had no problems.

What is the valid date format and why does it differ between projects and activities?


 
Posté : 10 Mar PM 16:033
(@babynus)
Posts: 14952
Membre Admin
 

Hi,

Date format do not differ from Projet and Activities.
What I guess is that you opened your file with Excel to edit it and saved from Excell : it is Excell that changes date formats.
Expected format is YYYY-MM-DD : international format, with no ambiguity about day and month and supporting sorting.


 
Posté : 10 Mar PM 16:033
(@tjaeckle)
Posts: 15
Active Member
Début du sujet
 

That was exactly the problem.

Thank you!


 
Posté : 10 Mar PM 17:033
Share:
Retour en haut