Hi BW experts!
I have a key figure (last date) defined as DATS and aggregation defined as MAX.
In my provider the data was storaged correct, as following above:
(dates in format dd.mm.yyyy)
. Customer 1, last date 21.03.2006;
. Customer 2, last date 10.03.2006;
. Customer 3, last date 26.01.2006.
But, in my queries (by EXCEL) these data are showed so:
1 | 21/03/2006
2 | 03/10/2006 (incorrect, correct is 10/03/2006)
3 | 26/01/2006
I checked my pc and SU01 configurations. In both of them there are date format dd/mm/yyyy.
Anybody can help me. please?