After copying and pasting the bulk data, the invoice date is incorrectly adjusted. It seems that the days are swapped with months.
before update:
after pasting:
result:
After copying and pasting the bulk data, the invoice date is incorrectly adjusted. It seems that the days are swapped with months.
before update:
after pasting:
result:
There have been a few messages about this lately.
Search the forum for recent responses
I think @lubos should really consider restricting date value storage and batch import / update to ISO format since it’s now natively supported by all major OS as well as spreadsheet apps.
I don’t think any more time should be wasted dealing with format inconsistencies when this entire situation can be avoided by standardization.
@Frankie what version are you currently using? I thought this has been already fixed.
Hi @lubos, 21.5.16 - W10 - desktop. There also seems to be a problem with crlf in a cell. It seems that these disappear when copying and pasting. If I can figure it out I’ll let you know.