Notifications
Retirer tout
Submit issues
2
Posts
2
Utilisateurs
0
Reactions
2,861
Vu
Début du sujet
Using Projeqtor V7.0.5 and screenCustomization v5.1 plugin, I have craeted new text fields on the Tender object. When I export some tenders, the custom text fields are converted in date fields depending on their content : 2/4/6, or 10/20/70, or 2-4-6, or 10-20-70.
That doesn't happend with space or dot : 2 4 6 or 2.4.6, or if I add few additional characters : 2/4/6 months or 10/20/70%.
Custom fields are defined as varchar. Shoud I use another type?
Posté : 26 Avr AM 11:044
I think the export is correct, but you open it with Excel : it is Excel that convertes data into dates because it looks like dates
Try and open exported file in text editor (notepad or notepad++) : you should see correct data
Posté : 26 Avr PM 13:044