There is a bug related to dates that afflict many aspects of Manager, ie Custom Fields / Custom Report / Batch Create / Batch Update.
The premise is that my preferences manager are:
so my date format is dd/mm/yyyy and the same is in Excel.
Here comes the problems that are all linked:
- custom reporting shows date of custom fields with a different date format;
- when I export a list for batch update I get two different date format, a correct one for transaction date and wrong ones for custom fields. When I import them in excel, it automatically converts them in the correct format but with errors when the day is <= 12 since it cannot distinguish which is the day and which is the month. When I import it back it completely messes up the dates;
- when I export a list for batch update I have also problems with text custom fields. I use a custom field to store suppliers’ invoice numberings that are all in different formats. For example I can have 10/2020. When pasted into Excel they are converted into a date “Dec/2020” and so when imported beck I get this text messed up.
- when I batch create some data I got the same prime as point 2 for dates in custom fields since it switches days and months if days are <=12.