Hello everyone,
I'm running into a weird bug when importing dates from Excel ( Microsoft Excel for Mac version 16.55) as my document variables.
In importing the following text value 11/1/1734 from Excel it is imported in MAXQDA as 10/1/1734.
In importing the values I set variable type to "date/time", the reason it's text in Excel is because Excel doesn't recognise any dates older than 1900 as a date.
Any date values I import in this manner, is subtracted by one day. For example three other values in my table are:
14/5/1735 -> 13/5/1735
6/10/1735 -> 5/10/1735
5/1/1735 -> 4/1/1735
Is this a known issue? Thanks in advance.
Version: MAXQDA 2020
System: Mac OS X 11.x (Big Sur)