We've an input-ready date field in a BEx Analyzer workbook. The field is a key figure in the corresponding query and the cube defines it as date (type dec 9).
If we enter a date (format DD.MM.YYYY) like '01.10.2012' the system will make a '40.452,00' out of it, when leaving the field. After saving the data in the workbook the date will be displayed as '03.10.0111', which should be 40.452 days after 01.01.0001.
Anyone here, who has already faced this problem?