Thank you for the valuable work you continue to carry out.
I’m reporting a problem importing the “invoices” module from a CSV file created with SuiteCRM v. 7.14.6. Despite the accuracy of the CSV file, the data is mixed up during the import, so invoice number 1 does not match the one actually issued (which was number 34). Furthermore, the invoice’s issue date and expected date are changed (in the original, the date was 31/03/2025 and has been changed to 07/01/2027). I hope this has provided you with useful information. And thanks again for your continued support!
I believe the problem is that in some modules (e.g., invoices, contracts), even though the date is generally set to the d/m/y format in the local settings, it is still handled in the m/d/y format. This causes the original date to be modified during import, while when viewing and printing, it ignores the general format and uses the m/d/y format.
Hi, @maxmaimax ! Welcome to the Community 
I moved your posts to a separate thread, the announcement thread is not a good place to troubleshoot specific issues.
I believe your diagnosis can be correct - that problem with date formats makes sense to me. The SuiteCRM database uses a standard timezone. When the dates are saved, they always get changed to that timezone; when they are read and displayed, they are converted back to the user’s timezone.
Remember that a single SuiteCRM installation can span multiple time zones (when used internationally, or in countries with multiple timezones).
1 Like
The Date Format with / is considered to be m/d/Y (by php date) so if you have d-m-y you can just use the Dashes to import the data to keep the Values Accurate. Then the Local settings will apply and show the User Format.
2 Likes
Thanks for your replies! They helped me think about the different steps I took during the import. The solution was very simple: once I set the global international settings, I didn’t check the advanced user settings; that remained in the m/d/y format. Changed and fixed it.
Now I’ll try importing some more data, and I think it will work. Maybe I’ll let you know. Sincere thanks.
1 Like